This is something you can type into a Query Analyzer window (which you can launch from the SQL Programs group or within Enterprise Manager). I see Jacob replied amidst all this and mentions the Enterprise Manager has a right-click option under the database, which might be a cleaner method for this.
And yes, I think your parameter descriptions are correct (though I confess I don't use this command much!). -----Original Message----- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 10:27 To: SQL Subject: RE: .mdf file - please help this rookie Thank you Tim. As stated earlier, I am a newbie. exec sp_attach_single_file_db 'Customer', 'c:\Microsoft SQL Server\mssql$engone\data\customer_data.mdf' Is this something I type in a DOS prompt or is there another command line interface for SQL? Also, can the above be read as where the 'Customer' can be whatever I want the db to named, and the 'c:\...' is the physical location of the file that I want to attach? Thanks, Charles > -----Original Message----- > From: Raster, Tim [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 23, 2004 10:47 AM > To: SQL > Subject: RE: .mdf file - please help this rookie > > > Ahhh, that's a good one. > > Well, if you must, you can try this URL: > > http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c04ppcsq.msp > x > > And look at the Attach section about 2/3 they way down... > > > > -----Original Message----- > From: Charles Nahm [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 23, 2004 09:48 > To: SQL > Subject: RE: .mdf file - please help this rookie > > > -----Original Message----- > > From: Raster, Tim [mailto:[EMAIL PROTECTED] > > Yikes. MDFs are the data files in their native format. It is not > > advised to try to move those from server to server. It would be > better > > for them to create a backup of the database, which copies the contents > > into a (usually) .BAK file. Then you would "restore" this .BAK file > to > > an empty database on your server. SQL2k can read SQL7 .BAK files just > > fine. > > Thank you for your quick response Tim. The problem we have is that the > current host is being very difficult in their handling of the possible > loss > of this client and are not being helpful at all. It has been like > pulling > teeth just to get to this point. If there is any way to work with the > MDF, > we would like to avoid having to make the client go back and contact the > host. > > > All he has to do is right-click on the database in his Enterprise > > Manager, hit Backup, and tell it where to put the .BAK file. Simple. > > > > The client is completely non-technical and in fact has no physical or > even > remote desktop or terminal service access to the machine hosting the > database. > > Thank you, > Charles > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2081 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
