Post reply

Getting error:(Urgent Help required)- RESTORE DATABASE is terminating abnormally.RESTORE requires MAXTRANSFERSIZE=1048576 but 196608 was specified.

  • May 10, 2012 at 12:07 am

    #256283

    Hi All

    I am restoring Lite speed backup to create a new db but getting the this error please suggest its urrgent..!!!

    RESTORE DATABASE is terminating abnormally.

    RESTORE requires MAXTRANSFERSIZE=1048576 but 196608 was specified.

    Thanks in Advance..!!

  • May 10, 2012 at 1:17 am

    #1485501

    Set the size while restore

    MAXTRANSFERSIZE

    Specifies the maximum size of each block of memory to be used when SQL Backup stores backup data. You may want to specify this argument if a SQL Server reports that it has insufficient memory to service requests from SQL Backup.

    Valid values are integers in multiples of 65536, up to a maximum value of 1048576.

    For example:

    MAXTRANSFERSIZE = 262144

    If not specified, defaults to 1048576. However, if you have created the following DWORD registry key, SQL Backup uses the defined value as the default value:

    HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>\MAXTRANSFERSIZE (32-bit)

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>\MAXTRANSFERSIZE (64-bit)


    - Pradyothana     http://www.msqlserver.com

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

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