We have been doing that....not working.

We have no SP installed on Live but have SP1 on Test.

Probably there have been FIXes to this problem.
We need to install the proper SP all round.
I think the solution lies here.

John

-----Original Message-----
From: trainr
[mailto:mssqldba-ezmlmshield-x53800633.[Email address protected]
Sent: 30 April 2007 07:40 PM
To: LazyDBA Discussion
Subject: RE: SQL 2005 Backup set holds a backup of a database other than
the existing datbase?



Should be under Options in the upper left corner of the restore box in
SS2005.

Quoting John King <mssqldba-ezmlmshield-x2386304.[Email address protected]

>
> Am using SQL 2005
> Can't use Enterprise Manager.
>
> Have done this plenty times in SQL 2000...however SQL 2005 not working.
>
> I have checked the Service Patches. None have been applied.
> I think therin lies the problem.
>
> Thanks for the Reply
>
> John
>
> -----Original Message-----
> From: trainr
> [mailto:mssqldba-ezmlmshield-x10651052.[Email address protected]
> Sent: 30 April 2007 06: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
>





---------------------------------------------------------------------
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