Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

log shipping, database already restored. Expand / Collapse
Posted Monday, August 26, 2013 7:20 PM


Group: General Forum Members
Last Login: Monday, October 7, 2013 4:29 PM
Points: 23, Visits: 146
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???
Post #1488520
Posted Monday, August 26, 2013 10:29 PM



Group: General Forum Members
Last Login: Yesterday @ 9:54 PM
Points: 1,963, Visits: 2,217
Yes the database on ServerB should be in NORECOVERY, you can select "the secondary db is already initialized" in the wizard.

Steps here
Post #1488545
Posted Tuesday, August 27, 2013 8:09 AM



Group: Administrators
Last Login: Yesterday @ 9:28 PM
Points: 34,372, Visits: 18,590
You can't put a database in norecovery. You have to restore it WITH NORECOVERY (or WITH STANDBY).

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1488796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse