+1 * *
*ASB* *http://XeeMe.com/AndrewBaker* *Harnessing the Advantages of Technology for the SMB market… * On Mon, Jan 9, 2012 at 5:39 PM, Damien Solodow <[email protected]>wrote: > 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: [email protected] [mailto:[email protected]] > 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 [email protected] > 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 [email protected] > 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 [email protected] with the body: unsubscribe ntsysadmin
