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 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 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...
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.
