Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Restore simultaneously from same backup file

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2010-09-17 : 07:19:16
I was wondering is it possible to restore 2 different databases from the same backup file at the same time?

Kristen
Test

22859 Posts

Posted - 2010-09-17 : 09:36:41
This so you can restore them "in sync" if you have a disaster?

If so, AFAIK, the answer is "no" and the best you can achieve is to have the databases in Full Recovery Model and restore using at STOP AT time, but whether this will restore them both to the identical transaction point, or not, I am not sure.
Go to Top of Page
   

- Advertisement -