Attach DB using MSDE

[password99]

I have a client using MSDE and needs to attach DB * LOG file to the DB server. How can they do that?

I was thinking they can use the OSQL utility intalled with MSDE? What is the command for attaching it?

 

[password99]

can i use isql utlility with named instance if there is only one instance installed?

 

[JayKusch]

Are they attaching the MDF and LDF, (Data and TransLog file)?

If so ... they would use sp_attach_DB. Here is the code straight from BOL (Books OnLine)

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'



Can they not just attach the DB thru Enterprise Manager?

Thanks

J. Kusch

 

[password99]

Thanks

Can they not just attach the DB thru Enterprise Manager?
They only have MSDE installed