MSSQL DB setup troubles

[JamesManke]

Hi there - I have NEVER had to set up a MSSQL DB before - I usally use MySQL. I have a client who wants me to transfer her site over to our new hosting and I need to find out how to set up the database. I have 2 files ( .LDF and .MDF) that were given to me to set this site up. I also have a SQL backup folder with a file in there with no extension.

How do I set up a MSSQL DB - please explain in easy terms - I know nothing about ASP (in which the site is programmed) and nothing about MSSQL.

Thanks for your help,

James

 

[JohnDTampaBay]

The MDF is the data portion of the database and the LDF is the log portion. Not sure what to do about the backup file. Here's the way to handle the other files. Good luck!

1 - Find out where data and log files are stored on the server. If no one can tell you off hand, check out other databases to see where their files are stored. In EM, right-click a database, choose Properties, check out the Data Files and Transaction Log tabs.

2 - Place the MDF in the location for data files and the LDF in the location for log files.

3 - In EM, right-click on Databases and choose All Tasks > Attach Database. Coomplete the Attach Database dialog box.



--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)