June 25, 2008 at 8:14 am
Hi Experts,
How to change a secondary database to primary in Logshipping???What are all the steps to be taken??
TIA
June 25, 2008 at 11:03 am
MSDN and Books Online have step-by-step instructions on this.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 12:54 pm
Try this
Restore all transaction log backups that have not yet been restored in the secondary database.
Kill all the users from secondary database to bring the database online. (if there are any)
Bring secondary database online/Recover.
RESTORE DATABASE WITH RECOVERY
Disable the existing log shipping jobs (optional).
Change application connection to use the new primary database.
Maninder
www.dbanation.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply