Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rebuild index space requirement

Status
Not open for further replies.
DaxDax

DaxDax

MIS
Jun 4, 2003
1
US
I have a 36 GB Sql Server database. (Sql Server 2000)

In previsous attempts to reorganize it, ie
xp_sqlmaint '-D DBNAME -RebldIdx 10 -RmUnusedSpace 50 10
... the job would fail due to insufficient space.
(There is some additional space now on the drive)

How does one estimate how much free space must be present on the drive where the database resides so a failure will not occur?

Can Sql Server be told to use additionally free space on another drive?

Thanks.

 
Status
Not open for further replies.

Similar threads

niall5098
  • Locked
  • Question
rebuilding indexes with always on
Replies
0
Views
98
niall5098
niall5098
niall5098
  • Locked
  • Question
understanding index rebuild
Replies
2
Views
87
niall5098
niall5098
Danster
  • Locked
  • Question
Rebuild index job massively increased DB size. How to get back down?
Replies
2
Views
296
mjldba
mjldba
GCL2007
  • Locked
  • Question
Log Files running out of disk space
Replies
4
Views
183
SQLBill
SQLBill
TheBugSlayer
  • Locked
  • Question
Partioning a table with non-clustered index but no clustered index
Replies
0
Views
74
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top