Dollars for donuts SQL is compressing the backup. :) That can be done either as part of the job or as a server wide default.
DAMIEN SOLODOW Systems Engineer 317.447.6033 (office) 317.447.6014 (fax) HARRISON COLLEGE -----Original Message----- From: jesse-r...@wi.rr.com [mailto:jesse-r...@wi.rr.com] Sent: Monday, January 09, 2012 4:44 PM To: NT System Admin Issues 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 listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ 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 listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin