Posted by Mark D Powell on 08/18/06 13:53

Erland Sommarskog wrote:
> Mark D Powell (Mark.Powell@eds.com) writes:
> > In the event of serious problems I will drop the database, recreate it,
> > restore using the backup over the new version, and fix the user access.
>
> You don't have to create the database prior to restoring it. RESTORE will
> do that for you.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I know a restore can recreate a database but since I want to change the
location of the datafiles will it in this case allow me to change them
on the screen where it shows the datafile names? I have changed them
when I overlaid a production database with a test (upgrade) version
that ran on the same server but I changed them to existing files for
the existing producion database that I wanted to overlay.

I should take a few minutes and try this on the test server.

Thanks -- Mark --

• Next in forum: Log Shipping Snyc Problem
• Prev in forum: Re: Using aba_lockinfo in a loop
• Thread view: Re: Best way to move datafile from C drive to D

[Reply to this message]