Dear All. I have my environment with SQL 2005 Databases and those Databases are configured with LogShipping Configuration.here i want to clarify one doubt related to detaching the Databases. my database has been configured the LS Process and i want to detach my database for some purpose. If Once i detach...

how to redirect the clients to the application after failover to secondary server in logshipping sqlserver 2005 i got this question in some interview "how to connect to the application after failover to secondary server in logshipping" thanks in advance

Hi, Sure, you can use your Mirrored database for the reporting purpose, to achieve this you should create a snapshot on mirrored database point all your reporting to it read article http://technet.microsoft.com/en-us/library/ms175511.aspx AFAIK, without breaking the LS we can not move it. Regards

Welcome to the Forums!! Did you go through this KB http://support.microsoft.com/kb/329133 If you go the the SQL Server logs on the secondary server it will tell you when the last log was restored for that particular databae, or right click on the job and say view history. By any chance do you or any...

Hi all, Here I am facing one issue in Log Shipping server: I have configured the Log Shipping in my production server and those databases are in Read-only/Standby mode for the purpose of Reporting Services. After configuring the Log shipping the login are not updated from Production server to Log shipping...

Hi, Yes. I'm getting this error. I've read a lot of posts on this error. 1. The date and time on both servers are exactly the same although the time on one server is on a 12 hour clock while the secondary server is on the 24 hour clock. 2. The log shipping Restore job that is running on the secondary...

[quote user="saigeeta"]The copy and restore jobs on the secondary servers do not seem to be working. The copy job is reporting as successful and the duration recorded for the copying is either 0 or 1 seconds in the job history.[/quote] Check the error log for the exact error message, also check...

Does a full/differential backup made using the backup dialog box in SSMS disrupt log shiiping of that database??? if Yes how can we take a backup of that system without disrupting log shipping

Good Day, We implemented Log shipping between 2 of our SQL Server 2005 servers . Afew day later tables were created on the Live database .The restore jobs were successful. We checked the Errorlogs of SQL Server and the report files of Log Shipping . They confirmed that the Logshiping was cmaking...