ADSM-L

Re: HELP Restore MS SQL Database

2002-02-07 08:13:15
Subject: Re: HELP Restore MS SQL Database
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Thu, 7 Feb 2002 08:02:34 -0500
> Sounds like you're trying to restore a database to the same machine.  You
> can't do that with SQL 7.  You have to restore the database to a
different
> machine or restore it over the existing database.

You should be able to do this for full backups using the
/RELOCATE and /TO options.  Take a look at chapter 6
of the TDP for SQL V2 User's Guide, under the description
of the /RELOCATE option.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"Celebrate we will. Life is short but sweet for certain..."  -- Dave
<Prev in Thread] Current Thread [Next in Thread>