I have a custom created c# application that backs up the Sql database.
It uses the Backup database databasename to file = 'backup file path and name' command.
It recently has been command timing out and failing to backup. Yes I can modify in the application to change the command timeout value, but I can't do that right now. Running the command in SSMS takes 32 seconds and completes.
I looked at the database mdf file size and its 990,504 KB and the ldf is 150,456 KB, so its not a massive database. The backup file created is 1,989,344KB, which is almost double the size of the mdf file. Since I want to speed up the backup (make it sub 30 seconds to complete) I was looking at reducing the size. What I can't figure out is why the .bak file is 1GB bigger than the mdf size.
any ideas or help greatly appreciated.