SQL Server Performance Forum – Threads Archive

SQL 6.5 – Space issues due to datafiles

All , There is some space issue in my T: drive (place where datafiles are kept – SQL6.5 ) .
Anyone have any idea how to proceed .Please tell me your thoughts.I feel lazy to go through version 6 documents, if anyone have experienced same issue, pls let me know.I wil start from that point . Pls note: I have only datafiles in that drive .
rajiv
NewBie-23

What kind of issues you’re having?
Do you want to attach those datafiles to database? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

nope I am receiving Bigbrother space alarm , sayin Drive T: is 96% full. That is the Drive where datafiles of 10 databases are kept .I want to freeup space to bring down threshold limit .Thats what i am confused with .

What is the freespace available on those 10 databases and how low you can shrink them.
You may try removing or moving other files from that drive. In SQL 6.5 you must specify the size of database as it will not get extended automatically unlike from version 7. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

SQL 6.5 , shrinking files/database need downtime 🙁 . rajiv
NewBie-23

No not required, rather I would say during less traffic hours <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ />. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

In some articles i found Datadevices cannot be modified after its been created.So how can i freeup some diskspace ? rajiv
NewBie-23

Satya, FYI, In SQL server 6.5 , Database should be in singleuser mode to perform a shrink operation .

]]>