SQL Express .bak file restore to SQL Server 2005 .... ERROR MSG... HELP.
-
I have an SQL Express .bak file of a dbase and I want to restore it to a dbase in my SQL Server 2005. The following message is all I ever receive:
-----------------------------------------------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3205)
-----------------------------------------------------------------------
I have SQL Server 2005 SP2 installed now, but that did nothing to help the issue.... anyone have experience in solving this?
Many thanks....
-
Did you installed SQL SERVER 2005 sp2 CTP because SP2 is not released?
Post the output of SELECT @@VERSION...
The following article applies to SQL 2000..
http://support.microsoft.com/kb/833710
MohammedU
Microsoft SQL Server MVP -
Hi Mohammed...
Yes, I installed SP2 CTP. I am using the right-click menu 'restore' utility in SQL Server 2005 to attempt to use the .bak file to restore the dbase. I don't know what you mean by 'Post the output of SELECT @@VERSION...' Here is the entire message and the only error information I have acces to:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.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
------------------------------
BUTTONS:
OK
------------------------------
Is there a separate SQL statement that you are talking about that will give me additional error information? Thanks....
Jeff
-
Just I want to make sure you are using 2005 so that i asked to post @@version output...
Try to restore through Query Window using RESTORE DATABASE command...
Are you overwriting the existing db or it is new db?
If you are overwriting the existing db check the cmpt level.
MohammedU
Microsoft SQL Server MVP -
Here is my version info MohammedU:
Microsoft SQL Server Management Studio 9.00.3033.00
Microsoft Analysis Services Client Tools 2005.090.3033.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML2.6 3.0 5.0 6.0
Microsoft Internet Explorer6.0.2900.2180
Microsoft .NET Framework2.0.50727.42
Operating System5.1.2600
Writing to a NEW dbase.
I will try to use the RESTORE DATABASE query you suggest. Thanks....
-
This could be bug in SP2 CTP
Post in Microsoft Forum...
MohammedU
Microsoft SQL Server MVP -
It's not a bug in SP2. The error occurred before I applied SP2, and now it occurs after SP2.
-
I would suggest ensuring that the backup file was first valid, as that error indicates that the header may be damaged. Try restoring that backup on a similar SQL Express instance.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply