Link to home
Create AccountLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

backup database with data transfer option maxtransfersize

Hi,
I see my backup database command doing this:

BACKUP DATABASE [TYRES] TO LARGEBACKUP
      WITH  MAXTRANSFERSIZE = 65536;

and backup was running extremely slow and according to micorsoft this value can be increase max to 4MB, is there any risk if I increase it higher than a default? right now maxtransfersize is only 16kb?
ASKER CERTIFIED SOLUTION
Avatar of SQL_SERVER_DBA
SQL_SERVER_DBA
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account