Looks like this was due to SQL 2008 R2s ability to do compression for SQL backups.
Original Message: ----------------- From: [email protected] [email protected] Date: Mon, 9 Jan 2012 16:44:15 -0500 To: [email protected] Subject: SQL Backup I'm finding this odd. I have a SQL 2008R2 Database set for Simple Recovery Model. The database is showing 71GB in size according to the .mdb file. of that, maybe only 3GB is free/unused space. When running backups of that database from the SQL management studio, the backup file, upon completion, is only 23GB or so in size. (the backups resides on a remote server and backup is done via UNC pathing) I don't understand how that can be correct. Seems like I'm missing a lot of data here in the backup file? What can I check to verify this? (please note my DB/SQL skill are not worth a darn... so dumb-down any responses requiring things to be checked in SQL, ha) -------------------------------------------------------------------- mail2web.com What can On Demand Business Solutions do for you? http://link.mail2web.com/Business/SharePoint ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin -------------------------------------------------------------------- mail2web - Check your email from the web at http://link.mail2web.com/mail2web ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
