Hi, I am trying to set up log shipping between two servers. The secondary database is Read-Only. Everything seems to be working fine for a short...
Hi Satya, Thanks for your information. As you said what privilage required for SQL Server service account to perform such activities on this...
Hi All,I have set up maintenance plan to take backups on daily basis. I want to keep two days latest backup, so to do that I have clicked “Remove...
Hi, I got 10 GB backup file from my manager to restore on some other server. I crated new database and restored the backup file. After restoring the...
Hi, I heared that we can apply trigger at server level in sql server 2005. If that is true, I would like to write a trigger on server so that who...
Hi All, I have very simple issue. please help me on this. I was moving XYZ table records from SQL SERVER to ORACLE database in a same box server...
Hi All, I want to calulate find out total downtime for a database in a month. Can I have procedure to find out the down time, if not please suggest...
Hi Satya, Thanks for your reply.. I believe you clear with my query. I have one dumo HTML page in c: drive. In that page have Table which have...
Hi All, I have html page which have table. HTML Table record have backup failure info. I want to extract table records from HTML page to sql server...
Hi, I am new to clustring concept. I am learning this concept. Can I set up Active and passive nodes on same Box ? I mean, want to set up two nodes...
Hi, I am facing comman problem. issue is , in box i have installed both sql server 2000 and sql server 2005. But i was unable to start sql server...
Dineshasanka and Satya, thanks alot.
Hi, Can anybody suggest me good books to learn Database Security and Sql Server Security concepts. I am very much interested to learn data,...
Separate names with a comma.
