August 26, 2013 at 7:20 pm
I am doing log shipping from server A to Server B. I have already restored the database (adventrueworks) on server B (from taking backup from server A)
My question is should I put the database on server B on norecovery mode and start log shipping OR should I delete database on Server B and start Log shipping all over again???
What is the procedures if server A and serve B have the same database (server B database is restored from server A database backup)
Any suggestions???
August 26, 2013 at 10:29 pm
Yes the database on ServerB should be in NORECOVERY, you can select "the secondary db is already initialized" in the wizard.
Steps here
http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/
August 27, 2013 at 8:09 am
You can't put a database in norecovery. You have to restore it WITH NORECOVERY (or WITH STANDBY).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply