Re: Restore a backup over a current SQL Dbase

2002-12-31 Thread Steven A. del Sol
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: >

Re: Restore a backup over a current SQL Dbase

2002-12-31 Thread Jon Hall
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

Restore a backup over a current SQL Dbase

2002-12-31 Thread Rebecca Joy Sherman
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