Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2009-12-02 : 05:02:38
|
| Hi.I have mdf file size of around 670 MB.and when i take a full backup(.bak) file showing 4.5 GB(approx.).The thing was i had one 4 GB (Approx.) userdefined log table in this datbase but i deleted that from that onwards its showing backup file size as 4.5 GB(approx.)Any Ideas plz... |
|
|
abeman
Starting Member
3 Posts |
Posted - 2009-12-02 : 06:10:53
|
quote:
Originally posted by learntsql
Hi.I have mdf file size of around 670 MB.and when i take a full backup(.bak) file showing 4.5 GB(approx.).The thing was i had one 4 GB (Approx.) userdefined log table in this datbase but i deleted that from that onwards its showing backup file size as 4.5 GB(approx.)Any Ideas plz...
probably using full logging , so therefore the MDF and LDF make the total size of the BAK file , check the DB.ldf , bet it is massive!! |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-12-05 : 05:52:56
|
| Depending on your recovery policy - you may want to truncate the log prior to commiting the Backup. Although this will limit the ways in which you can recover. On some of the databases I look after , we do an hourly log backup - (including truncate) and then one full backup at the end of the dayJack Vamvas--------------------http://www.ITjobfeed.com (IT jobs) |
|
|
|
learntsql
524 Posts |
Posted - 2009-12-06 : 23:46:54
|
| Thank you for your reply.We use Simple recovery model.and my backup plan as daily twice full backup.I dont take any log back upCould you plz. guide me the best Backup and Recovery strategy(any links)as of now we are not implementing but we are going to implement these. |
|
|
|
|
|
|
Difference between .mdf and .bak size?