Microsoft.SqlServer.Express.ConnectionInfo
(1)
SQL Server
(1)
CREATE DATABASE
(1)
Exception
(1)
Backup
(1)
Database
(1)
LinkId
(1)
Sysindexes
(1)

Help Restoring Database

Asked By Zachary
27-Aug-09 05:28 PM
Here is the scoop:



A PC of ours started to die.  Before it was fully gone I used SQL Management
Studio Express to make a backup of the MSDE 2000 databases.  I also copied
the mdf and ldf files from the Program Files folder.  Now when I try to
either restore from the backups to a new database, or when I try to attach
the mdf or ldf files to a new database using SQL Management Studio Express
it bombs out on me.  Before the PC fully died I even tried using the Data
Publishing Wizard to script it and that failed.  I have even wrote a
detach.sql and attach.sql scripts and the detach works fine but the attach
bombs.  Any insight would be greatly appreciated.



Restore to blank database:



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



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



------------------------------
ADDITIONAL INFORMATION:



Too many backup devices specified for backup or restore; only 64 are
allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error:
3205)



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



Attaching the mdf and ldf files to a new database:



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



Attach database failed for Server 'agra-004\sigmanest'.
(Microsoft.SqlServer.Express.Smo)



For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.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.Express.ConnectionInfo)



------------------------------



Could not find row in sysindexes for database ID 6, object ID 1, index ID 1.
Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'SNDBase2'. CREATE DATABASE is aborted.
(Microsoft SQL Server, Error: 602)



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



Here is the script first:

use master
go
sp_attach_db 'SNDBase','C:\Data\SNDBase2.MDF','C:\Data\SNDBase2_LOG.LDF'
go

Richard Mueller [MVP] replied to Zachary
27-Aug-09 09:03 PM

         
Post Question To EggHeadCafe