What are .mdf files and how do I use or open them? I have two .mdf files, but have no idea how to open them.
SQL Server creates an .mdf and an .ldf file for the database and the associated log. If you have both of them, you can attach them to your server. For more info, open up Books Online and read about attaching a database.
Thanks,
Sam Lester (MSFT)
|||In addition, if you don′t have any ldf file you can try to let SQL Server create a new one for you during attaching the file with sp_attach_single_file_db. If SQL Serve dcan reconstruct the concistency of the database without the ldf file it can create a new one. (Not guranteed that you will have logical concistency across your database)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||I don't have an .ldf file and want to access the .mdf file. How do I attach it to the database? I don't have SQL Server. What should I do?
No comments:
Post a Comment