Post reply

RESTORE fails with MAXTRANSFERSIZE error

  • September 12, 2008 at 2:53 am

    #212568

    When trying to restore a SQL DB from a client A to another instance in a different client ,say B, I get the following error:

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

    Error has occurred while executing a SQL statement.

    Error message: '

    [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE requires MAXTRANSFERSIZE=262144 but 65536 was specified.

    [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.'

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

    Both the source and instance are SQL 2005. Please let me know if you have some information/suggestion.

    Thanks,

    Anb

  • September 12, 2008 at 3:11 am

    #870830

    What happens if you try doing the restore via T-SQL script?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply