asked on

What can I do with a SQL Server Database Primary Data File and Transaction file

I am going through a ADO.Net Training Kit from a book. It comes with a Database Primary Data File and Transaction file. How do I install the database to work on ADO.Net Exercises.

ASKER CERTIFIED SOLUTION

skarai

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

sachinpatil10d

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tommym121

ASKER

I got the following errors when I try to attach the database.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'GUNDAMZ\SQLTEST'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617.0+((KJ_RTM_GDR).110422-1901+)&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:\MSSQL\DATA\VideoGames.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)

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

------------------------------
BUTTONS:

OK
------------------------------

tommym121

ASKER

Got it I need to give write permission to the database file Thanks.

tommym121

ASKER

Thanks.