Here is my snippet...I think I even got it off this list many moons ago. First Step - get database name:
restore filelistonly from disk = 'c:\medop.bak' Second Step: restore database medop from disk = 'c:\medop.bak' with move 'medop_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\medop.mdf', move 'medop_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\medop.ldf' In case you have active users when you need to restore, I use this sp to disconnect them. Careful with this one though... http://www.swynk.com/friends/knight/killusers.asp -- Jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 12:21:19 PM, you wrote: DD> I have a back up of a db in SQL 7 that I need to restore on my live DD> server. When I do the transfer and then try to open up a table I get an DD> error that says "Query designer encountered as query error." DD> Can anyone please tell me the proper steps to get this db up and DD> running. DD> TIA DD> DDINC ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
