Restoring from .MDF/.LDF

Hi there,

I've got a .mdf/.ldf database/log. I'm trying to bring it into SQL Server Management studio, but can't figure out how. I've gotten as far as "Attaching" it, but can't figure out where to go from there. Can anyone help me out. I know this is very basic.

Thanks.

First of all, you cannot "Restore from MDF files"

Hi,

place the mdf /ldf file somewhere you want to keep them in the future. Then you will have to use the attach dialog you already found and attach the database files. If the logfile path points to another direction than it is currently stored in, change it and click ok. SQL Server will attach the database and open it for further use.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Moving database from SQLS2k5 to SQLS2k5Express may be not easy!

I have obtained customer DB which was detached from SQL2K and attached it to SQL2005 Express.

I found that all tables are presented in form DBA.<table name> and simplest query

SELECT * FROM <table name>

results in error message saying something like "object name <table name> is incorrect" while query

SELECT * FROM DBA.<table name>

goes successfully.

Well, what should be done in this case?

Thank you.

|||

Hi,

Try using "USE [DB_NAME]" command before using SELECT statement.

Hope this would help.

Shakeel

|||Thanks everyone. This was all very helpful!