September 11, 2008 at 6:07 am
Dear All,
I am trying a backup and restore of MS-SQL server 2005. The backup went through but the restore failed with the below error:
RESTORE requires MAXTRANSFERSIZE=262144 but 65536 was specified.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is
terminating abnormally.'
Please provide me information/suggestion.
Thanks,
Anb
September 11, 2008 at 7:01 am
Are you perhaps trying to restore a 2005 database to SQL 2000?
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
September 11, 2008 at 2:01 pm
You may need to set maxtransfersize in your backup statement.
September 12, 2008 at 12:50 am
Gail,
No, it is MS-SQL 2005 to MS-SQL 2005.
Regards,
Anb
September 12, 2008 at 12:52 am
The parameter MAXTRANSFERSIZE is set to 65536.
September 12, 2008 at 1:29 am
Please post SQL 2005 questions in the SQL 2005 forums. If you post in SQL 2000 forums, we're going to assume the question has soemthing to do with SQL 2000.
How are you doing the restore? Via the gui or via T-SQL
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
September 12, 2008 at 2:58 am
Thanks. I have posted in SQL 2005 forum. And the restore happens through GUI.
September 12, 2008 at 3:08 am
I meant next time you post. Otherwise it'll be answered in both places with people suggesting stuff that's already been suggested.
Thread continues:
http://www.sqlservercentral.com/Forums/Topic568342-149-1.aspx
No replies to this thread please.
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply