| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-12-25 : 05:49:44
|
| My db and backup is very largeis there anyway of compresssing it? or at least analyzing what's so big?when i delete data does it make the db smaller? (it doesn't seem to me like it does. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-12-25 : 10:09:34
|
| If you delete data in the database, it will leave free space inside the database file(s). You can then shrink it down using DBCC SHRINKFILE. Don't shrink it unless you know for sure you don't need it in the near future as shrinking it down will cause big performance problems if it needs the space again. You can compress the backups using third party tools such as Lumigent's SQL Litespeed and Red Gate's SQL Backup Pro.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-12-25 : 12:40:40
|
| DBCC SHRINKFILE (<FileName>, <TargetSize>) WITH NO_INFOMSGSWhat filename do I use and How do I know the target size? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-12-26 : 05:34:30
|
| where do I see the logical filename?and is the size in MB?where is the disk usage report?thanks |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-12-29 : 14:01:12
|
| Right click the database and go to propertys,In files pages you will find the logical names,filetype,initial size.If you right click the database,there is an option reports,go to standard reports and select disk usage. You will find all the details.Hope this helps. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-29 : 14:10:58
|
quote:
Originally posted by swekik
Right click the database and go to propertys,In files pages you will find the logical names,filetype,initial size.If you right click the database,there is an option reports,go to standard reports and select disk usage. You will find all the details.Hope this helps.
i've heard some of standard reports are only available from sp2 onwards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-12-29 : 14:22:40
|
Yes ,It requires SP2quote:
Originally posted by visakh16
quote:
Originally posted by swekik
Right click the database and go to propertys,In files pages you will find the logical names,filetype,initial size.If you right click the database,there is an option reports,go to standard reports and select disk usage. You will find all the details.Hope this helps.
i've heard some of standard reports are only available from sp2 onwards
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-31 : 21:33:45
|
quote:
Originally posted by esthera
DBCC SHRINKFILE (<FileName>, <TargetSize>) WITH NO_INFOMSGSWhat filename do I use and How do I know the target size?
Booksonline has details about it. |
|
|
|
|
db adn backup is very large