|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Restore using Mgmt Studio only recognises first dump in backup device(Tested on Developer edition running on XPSP2 & Enterprise Eval running on Windows 2003 SP1) 1. Create a backup device Device1 2. Backup AdventureWorks to Device1 3. Backup OtherDB2 to Device1 with NO Init 4. Try to restore the OtherDB2 using Management studio. Select "From Device" and select device1. 5. Go to Options - to see the list of files ... it shows Adventureworks files when it should show OtherDB2 files. Is this a bug ? And the best part ..... if you actually perform the restore ... it restores correctly... i.e the OtherDB2 eventhough it shows Adventureworks filelist in the options page. /sukhdev Sukhdev S (sukhdev@nospam.avantustraining.com) writes:
Show quote > Using SQL Server 2005. I think you should file a bug on > (Tested on Developer edition running on XPSP2 & Enterprise Eval running on > Windows 2003 SP1) > > 1. Create a backup device Device1 > 2. Backup AdventureWorks to Device1 > 3. Backup OtherDB2 to Device1 with NO Init > 4. Try to restore the OtherDB2 using Management studio. > Select "From Device" and select device1. > 5. Go to Options - to see the list of files ... it shows Adventureworks > files when it should show OtherDB2 files. > > Is this a bug ? > > And the best part ..... if you actually perform the restore ... it > restores correctly... i.e the OtherDB2 eventhough it shows > Adventureworks filelist in the options page. http://lab.msdn.microsoft.com/ProductFeedback/ for this. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |
|||||||||||||||||||||||
Other interesting topics