>I hope I did not confuse you.
I don't think so...but how can I tell!!!
>having multiple backup sets
No we don't.
Um...we recreated the test DB to look like the live...still same error.
I think applying Service Patches could sort things out.
regards
John
-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x39370905.[Email address protected]
Sent: 30 April 2007 06:42 PM
To: LazyDBA Discussion
Subject: RE: SQL 2005 Backup set holds a backup of a database other than
the existing datbase?
Another possible issue when you backup source db and did not specify to
overwrite the existing backup, you ended up having multiple backup sets.
So when you try to restore your backup on destination server it doesn't
know which backup set to use.
I hope I did not confuse you.
Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)
-----Original Message-----
From: trainr
[mailto:mssqldba-ezmlmshield-x10651052.[Email address protected]
Sent: Monday, April 30, 2007 12:38 PM
To: LazyDBA Discussion
Subject: Re: SQL 2005 Backup set holds a backup of a database other than
the existing datbase?
You have to force the restore. If you're using Enterprise Manager
there is a checkbox on the second tab of SS2000 for forced overwrite.
I can't remember the syntax if you're doing this from Query Analyzer,
but you can cut and paste from Books Online. It tells you how there.
Quoting John King <mssqldba-ezmlmshield-x59498068.[Email address
protected]
> 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]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page