Hi,
1) We will setup logshipping for a large database.
2) 2 systems are located at different city
3) Instead of use 'backup from primary and restore with norecovery to secondary ', we planned to use
SAN disk clone to get a second set of disks for related database files and log files.
4) We will mount the disk to the secondary server, however, how can we put the database on the new
server as 'norecovery' mode so that we can setup logshipping to this server
Another easy example is:
1) detach database
2) Copy database files to another disk
3) bring the disk to another city and attached to the new server
The database is recoveryed, how can we attach the database or mount the disk and make
the database as norecovery so that we can keep apply new logs
For 2 identical database image, how can we toggle one from normal to norecovery to setup logshipping
Is change 'status' from master database working
Thank you very much for any words.
If this is the wrong forum, please point me to a correct one since I am new here and I can't find a
backup/restore related forum.
Jane
Can we toggle the database status between recovery and nonrecovery?
Stefaan Meeuws
Neither of the scenarios that you note will work.
You need to backup the database, transfer the database to your remote location, and then restore the database specifying either NORECOVERY or STANDBY for the options. Then transaction logs can be applied. Logs can only be applied to a full backup that has been restored and left in either norecovery or standby mode. There aren't any ways around this.