Error when accessing sample databases

Hey, Everyone - I have downloaded two of the sample databases and get the following error when I attempt to open them:

Unable to open the physical file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Assets_Maintenance_log.ldf". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120)

So what am I doing wrong? The install of these sample databases is simple and straight-forward.

Thansk!

Regards,

Bob Mitchell

Hi,

The database file won't open this way, you have to go through the SQL Server Management studio, the file you are trying to open is ldf (Transaction Log file).

If you have just copied/extracted .mdf and .ldf files then you need to attach them using your SQL Server Management Studio, to do this

Open your SQL Server Management Studio -> Login to your Server -> Expand your server-> Expand Database Folder -> right click on Database folder -> click on attach-> select the .mdf file from the location you copied/extracted database files-> ok

this will attach database to your server, then you need to query it through query analyzer window or you may browse/open table from management studio.

Feel free to ask if you have more doubts

HTH

|||

refer this link

Running Setup to Install AdventureWorks Sample Databases and Samples :

http://msdn2.microsoft.com/en-us/library/ms143804.aspx

Madhu

|||

Thanks for the quick replies! Unfortunately, I'm still having the same problem.

I download the database executable, sse-dm_01.EXE and run it. I select my H drive for the install. The executable extracts 5 files to the folder I have chosen. None of them is a *.ldf file.

When I go to attach the database, I get the error that file c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Assets_Maintenance_log.ldf cannot be found.

What I find confusing is that no *.ldf file is even extracted so even if I were able to point the attach to the H drive for the ldf file, it still would not find it.

Still need some help!!!

Thanks!

Regards,

Bob Mitchell

|||

Bob,

Have you found a solution to this problem?

I have been struggling with this same problem for a long time tonight, but I finally found the solution.

On the list of files at the bottom of the Attach Database screen delete the reference to the xxxxxxxx-log.ldf file that is listed as "Not Found." You can delete the reference to the file by selecting it and then pressing the Remove button. Once you have deleted the file then go ahead and click OK to complete the attachment to the database.

Hope this helps. It worked on the couple of samples I downloaded.

-eric