June 29, 2011 at 7:18 am
We normally backup the database and restore in the disaster recovery site bot in non recovery mode in order to activate the log shipping. We want to do the same but doing a backup of the mdf and log file, then restore the files in the disaster revocery site, attach the files but in not recovery mode. Ca I do that?
June 30, 2011 at 1:25 am
horaciovel (6/29/2011)
We normally backup the database and restore in the disaster recovery site bot in non recovery mode in order to activate the log shipping. We want to do the same but doing a backup of the mdf and log file, then restore the files in the disaster revocery site, attach the files but in not recovery mode. Ca I do that?
yes attaching the db in online (recovery mode)
attaching and restoring the database both are diffrent.
I'm not clear could you give me more info? What are you trying to do in DR site?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 30, 2011 at 6:35 am
No, you can't attach a DB and leave it recovering. To start a log shipping setup, you need to restore a full backup with norecovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2011 at 5:21 am
Attaching a database is actually performing CREATE DATABASE FOR ATTACH statement so,its not possible to come back at recovery stage
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply