Hey Trainr:

You're sending me 12 copies of the same message.

Steve


-----Original Message-----
From: trainr
[mailto:mssqldba-ezmlmshield-x73008305.[Email address protected]
Sent: Monday, April 30, 2007 1: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