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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-03-01 : 13:14:46
|
| I have a 160G database that is failing to backup due to insufficient space. In the database is a table that consumes 140G of space because of a text column (not my design). What options do I have to alleviate the failing backups? Thanks. - ray |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-01 : 13:23:27
|
| Your only options are to add disk space or backup to a remote server or tape that has sufficient space for this.Tara |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-03-01 : 13:29:01
|
| Can the large table be placed on a secondary file and backed up to a separate location or would that be making administration too difficult? - ray |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-01 : 13:31:49
|
| Yes you can do that too. I don't like going down that route though for something as easy as adding disk space. Disks are so cheap these days that not having enough disk space for backups isn't a good excuse anymore.Tara |
|
|
|
|
|
|
large DB failing to backup