Hard disk space is full

[manorajya]

Hi,
i'm having SQL Server 7.0 & the partion on which database is stored is full. i had another hard disk & want to know the options for adding the space to my database or moving the database.

Thanks in advance.

 

[Stamey]

You could add another file (create an MDF file and/or an LDF file) on the other disk(s) and expand the DB to use it, but this becomes cumbersome if you do not have a specific plan for spreading your DB files across disks. This is usually done for performance reasons.
You could back the DB up and restore it to the new disk. You could detach the DB from SQL Server and move one or more files over to the new disk then re-attach them (this one is probably the best, easiest, and quickest solution).
Look up sp_Detach_DB and sp_Attach_DB in Transact SQL help or BOL.

Chris