| Author |
Topic |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2011-06-14 : 12:40:49
|
| i have a db of size 93 Gb, there is one huge table with 200 million rows. if i move the table to a diffrent filegroup , will be database size get reduced. The reason im asking is the backups has been failing due to insufficent disk space. so trying to make the backup work. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-14 : 12:55:48
|
If I move my cupboard from one room to another room will the size of the cupboard get reduced? No.Look for a drive with more diskspace for the backup file.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-14 : 13:09:44
|
quote:
If I move my cupboard from one room to another room will the size of the cupboard get reduced? No.
I don't know about you, but whenever I have to move something that big, and I disassemble it, I always end up losing the hardware, and the instructions, and I hammer on it and glue it and duct tape it together, or try to, until I just give up and lay it on its side and PRESTO! new table. And it's smaller than the original, minus the extra pieces I throw away./stupid Ikea furniture |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2011-06-14 : 13:35:01
|
| i have sql server 2000 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
newdba
Starting Member
30 Posts |
Posted - 2011-06-14 : 13:58:08
|
| have you tried shrinking it ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2011-06-16 : 17:16:49
|
| that huge table does not have index |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
DATABASE FILE SIZE