September 29, 2003 at 1:27 pm
I have a database that has been mirrored and is now attached to another server. I also have a transaction log backup that I want to restore with to roll forward with.. How can I do this..
1 AM: Database files are mirrored then split.
6 AM: Transaction log backup of original database
... I want to restore the transaction log to the new database..
Any ideas?
"Keep Your Stick On the Ice" ..Red Green
September 29, 2003 at 1:56 pm
Let me try to explain a little better.
I have a database that has been attached to a new server. I wish restore transaction log backups to the new database. Any ideas on how this can be done?
"Keep Your Stick On the Ice" ..Red Green
September 29, 2003 at 2:42 pm
When you restore the full, you have to specify the "with norecovery" or with "standby" options. Then you can load t-logs. Need to be sure you do not complete recoery with them either until you are done with logs.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply