I have this particular scenario i use this script in a schedule job to backup my databases :
USE AccountsPayable BACKUP DATABASE AccountsPayable TO DISK = N'F:\DBBackup\AccountsPayable.bak' WITH format, init
And runs ok no error messages. but i notice if i go to the Path "F:\DBBackup\AccountsPayable.bak" the size of the .bak is 64594 kb
If i select the same Database on Microsoft Sql Server Managment Studio and rigth click, task, backup, and select the same path
"F:\DBBackup\AccountsPayable.bak" when the backup is completed the size of the database is competly differenten! is 129188 kb.! is double size!
Why this is hapenning?
Thank you for your help
View Complete Post