Hi All,

SQL 2005.

We have a Live and a Test databases.
Unfortunatly the Test database has a different name to the Live database.

We need to test the backup and restore.

When trying to retore the Live to the Test an error is returned.
"Backup set holds a backup of a database other than the existing datbase"

How do we work around this?


Regards
John King

This e-mail and its contents are subject to Albaraka Bank Limited's
Disclaimer and Confidentiality Clause, which can be viewed at:
http://www.albaraka.co.za/e-mail-disclaimer.htm Should you be unable to
access the link provided, please send a blank e-mail to
[Email address protected]


MS Sql Server LazyDBA home page