December 12, 2011 at 2:38 am
Good day all.
Please let me know if this is possible.
i have a server that has some faulty hardware, it just shuts down after running smoothly for a few hours.
We decided to move to another server.
I restored a backup to the new server ( norecovery) .
I have some differential backups that i can restore, but i do not have the latest differential backup.
Can i restore one of the latest older backups to the new server while i take a latest backup on teh faulty server.
That way i reduce the time to get the new server up and running to move to production.
So if the current differential backup fails due to the server shutting down , then i continue with the TL backup that i have after the latest differential. But then i have about 30 TL backups to restore , (time consuming)
other alternative :if the current differential backup doesnt fail and complete, then can i take that differential backup and restore after the first one was already done with no recovery. meaning can i restore 2 differentials instead of 1 differential and many TL backups.
Thank you
Imtiaz Mohamed
December 12, 2011 at 3:18 am
December 12, 2011 at 3:34 am
was posted in wrong forum
Should have been under teh sql 2008 r2 forum, under dba or administration, couldnt change teh topic ?
Sorry for the inconvienience / duplication.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply