Yes it is there...we have been checking the box. However the same error is
being reported.
The latest Service Patches should fix the Problem.

John

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



Could it be in the options in the upper left corner of the "restore" box in
SQL Server 2005?

Anonymous


>From: "trainr" <mssqldba-ezmlmshield-x53800633.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: SQL 2005 Backup set holds a backup of a database other
>than the existing datbase?
>Date: Mon, 30 Apr 2007 17:40:23 +0000
>
>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
>




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