June 23, 2008 at 10:07 pm
hi,
if a database size is 40mb, then full backup of this database(.bak file) will also have same size as database ,40mb? or it will be less?
June 23, 2008 at 10:30 pm
It could be less. If you are looking at the size of the mdf/ldf's, then you are seeing how much physical space the files are taking on the OS. There could easily be empty space in the data files available to SQL to store additional data. This is a good thing, unless disk space is at a premium.
😎
June 23, 2008 at 10:38 pm
my database size is 40mb, but the backup file size is about 10mb is that possible?
June 23, 2008 at 10:43 pm
Yes, that is possible - it means you have 10mb of data in the database and 30mb of space available (give or take a few mb) until the data file needs to grow.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 23, 2008 at 11:01 pm
hi,
I have a sql litespeed backup of db size 90 mb n it shows native sql backup is 15mb. I restored this db n took native sql full backup. .bak file is adbout 4mb?
why this is happening?
June 23, 2008 at 11:14 pm
How big is the log file for this database? What is the recovery model for the database? If full recovery, how often do you backup the transaction log?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply