I have a SQL Server 2008 r2 database that is currently 56 GBs. When I run the following code I get a bak file that is 93 GBs. What could be causing this?
BACKUP DATABASE [CommerceCenter] TO DISK = 'N:\MSSQL\DATA\CC\CC_backup_tues.bak' WITH COMPRESSION
If I use SSMS to run the backup to the same location with compression the bak file is only 8 GBs.