June 14, 2009 at 12:29 pm
Ok, I am setting up log shipping and everything seems to go as planned but the secondary database does not go into standby mode when the shipping is implemented. I can backup the logs and move them over to the backup server but I cannot restore as the database is not in standby mode. I select these options when I setup the job but they do not seem to be applied. Any ideas?
June 14, 2009 at 12:37 pm
kirkwilson (6/14/2009)
Ok, I am setting up log shipping and everything seems to go as planned but the secondary database does not go into standby mode when the shipping is implemented. I can backup the logs and move them over to the backup server but I cannot restore as the database is not in standby mode. I select these options when I setup the job but they do not seem to be applied. Any ideas?
what is the state of secondary database? (read-write state/restoring state?)
it seems you restored the full backup in RECOVERY mode????
June 14, 2009 at 12:49 pm
The database is in a normal state. I created the database and then used a current backup to restore it so it would be in sync with my production database. I cannot have the log shipping job create the database as the backup database is in another domain and I have to use a proxy to ge the backup logs. I change from sql agent to the proxy in the copy logs procedure.
June 14, 2009 at 12:55 pm
kirkwilson (6/14/2009)
The database is in a normal state.
If the database is in normal state, you cannot perform further restoration of log files.
The database must be either in NORECOVERY mode or STANDBY mode
restore your database again in STANDBY mode which will allow transaction logs to be restored in future.
June 14, 2009 at 12:59 pm
Thank you so much. I forgot all about the standby in the restore step.
June 14, 2009 at 1:03 pm
This link tells you on STANDBY clause when restoring via SSMS
http://msdn.microsoft.com/en-us/library/ms177429(SQL.90).aspx
This link gives u step by step guidance to setup up log shipping in STANDBY mode
June 14, 2009 at 1:06 pm
🙂 Glad you remembered that important step!!
June 14, 2009 at 1:14 pm
I am up and running, thank you Pradeep Singh!
June 14, 2009 at 1:18 pm
Am happy i was of some help 🙂
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply