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 Server\MSSQL\Data\dbname.mdf', move 'dbname_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\dbname.ldf' -- jon mailto:[EMAIL PROTECTED] Tuesday, December 31, 2002, 4:56:04 PM, you wrote: RJS> How do you restore a .BAK file over a current Database in SQL SERVER 2000? RJS> Joy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
