Post reply

SQL Express .bak file restore to SQL Server 2005 .... ERROR MSG... HELP.

  • February 1, 2007 at 11:12 pm

    #116102

    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....

  • February 1, 2007 at 11:44 pm

    #687314

    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

  • February 2, 2007 at 7:59 am

    #687420

    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

  • February 2, 2007 at 1:56 pm

    #687558

    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

  • February 2, 2007 at 2:15 pm

    #687564

    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....

  • February 2, 2007 at 5:29 pm

    #687603

    This could be bug in SP2 CTP

    Post in Microsoft Forum...

     

    MohammedU
    Microsoft SQL Server MVP

  • February 2, 2007 at 5:41 pm

    #687605

    It's not a bug in SP2. The error occurred before I applied SP2, and now it occurs after SP2.

  • February 2, 2007 at 8:33 pm

    #687613

    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