Problem recreating database

Had a crash and am trying to recreate my database. I have large files (200mb each)created using sql 7, a mdf and ldf file. When restoring on sql 2000 I get an internal consistency error trying to attach the mdf and ldf files. It fails half way through.

I desparetly need this database restored and would appreicate any help

Hi,

you could try to use the sp_attach_single_file_db and hope that this will be successfull. Seems that your database is inconsistent, do you have a valid backup ? That would be the best solution. Otherwise I hope for you that only attaching the MDF file with the above command works for you.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

sql

problem in Vista RC1

I have just installed Windows Vista RC1, installed SQL Server 2005 Express and the SQL Server Management Express..

Now I want to attached mdf file but I am getting this error:

TITLE: Microsoft SQL Server Management Studio Express

Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

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

The server principal "Jassim-PC\Jassim Rahma" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)

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

BUTTONS:

OK

I just blogged about this issue, check it out.

Mike