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: >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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
