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.
| 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.regardssiva |
|
|
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 NORECOVERY2. someone explicitly changed the database state e.g.RESTORE DATABASE ... WITH NORECOVERYI 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 MondSQLBackupRestore.com - your quick guide to SQL Server backup and recovery issuesSQL 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 |
 |
|
|
|
|
|
Log shipping - standby / read only mode