Attaching a rs2005sbsDW.mdf

Hi all,

I am trying to attach a database using the sample files that come with Microsoft SQL SERVER 2005 reporting services. When I try to attach it fails. What causes this error message?

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'CITS-D011'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Unable to open the physical file "C:\rs2005sbsDW\Setup\Database\rs2005sbsDW_Log.LDF". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

BUTTONS:

OK

This error is the logfile. When I try to creae the path by creating directories under drive C, it still fails to attach.

Please help me out.

Ronaldlee

I solved this problem by deleting the incorrect path "C:\rs2005sbsDW\Setup\Database\rs2005sbsDW_Log.LDF"

Thanx

|||

I solved the problem by deleting the incorrect path of the log file.

Thnx.