Pardon my ignorance but no the same server. I fragged a database and need
to restore a previous version.. Please help.
At 06:06 PM 12/31/2002 -0500, you wrote:
>I assume you mean to a different server, if same server just use
>enterprise manager wizard.
>
>First Step - get database name:
>
I assume you mean to a different server, if same server just use
enterprise manager wizard.
First Step - get database name:
restore filelistonly
from disk = 'c:\backup.bak'
Second Step:
restore database dbname
from disk = 'c:\backup.bak'
with move 'dbname_Data' to 'C:\Program Files\Microsoft SQL
How do you restore a .BAK file over a current Database in SQL SERVER 2000?
Joy
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscrib
3 matches
Mail list logo