Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Log shipping - standby / read only mode

Author  Topic 

datosiva
Starting Member

18 Posts

Posted - 2010-08-11 : 23:23:59
Dear masters. Need you assistant.

I configured log shipping in my prod env and dr machine.
Configured successfully and all the backup, copy and restore job went through smoothly for a week. Later then I checked one of the standby database turn into restoring mode. It supposed to be in Standby / Read only mode. All the log were applied successfully.

My question is why the database at DR turned to restoring mode instead of standby/read only mode?

Any of you face this before. Please share your valueable exp.

regards
siva

Yeoh Ray Mond
Starting Member

49 Posts

Posted - 2010-08-12 : 09:53:33
Two possibilities:

1. someone performed a restore with the NORECOVERY option e.g.

RESTORE LOG ... FROM DISK ... WITH NORECOVERY

2. someone explicitly changed the database state e.g.

RESTORE DATABASE ... WITH NORECOVERY

I would suggest checking the SQL Server logs and also the backup history tables in the msdb database to see if there were any unplanned restores.

Ray Mond
SQLBackupRestore.com - your quick guide to SQL Server backup and recovery issues
SQL Image Viewer - retrieve, view, convert and export images and binary data from SQL Server, Oracle, DB2, PostgreSQL, SQLite, and Firebird databases.
SQL Data Sets - share and distribute SQL Server, Oracle and PostgreSQL data sets securely and easily
Go to Top of Page
   

- Advertisement -