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 |
|
Richard101
Starting Member
30 Posts |
 Posted - 2008-11-26 : 06:32:09
|
| Hi AllI've had a spate of space-issues lately where a single data-file is over 100 GB in size (and is too big to backup or manage).Has anyone read of a best-practice document where data-file sizes are 'capped' at -say- 20 GB and another one started? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-26 : 07:33:39
|
| You could have spread data files accross multiple drives to reduce I/O contention issue and space issues. |
 |
|
|
|
|
|
managing large databases