Can I move my data file and log file to a different drive?

[Guest_imported]

I have a 30 Gig hard drive that has been partition into C and D drives with C only 2 Gig and the rest go to D. So far most of my SQL Database has been created on C drive (with the data file and log file located in C) and it is running out of room. My question is can I move everything (all database) to D drive?
Note that most of the database use FontPage on the other end. Therefore if I move the DBs to D drive, can the Fontpage still be able to access them?

Thanks for help.

 

[vadimg]

If you are using SQL 7 or SQL2K

1. Make sure there are no user processes in the database.
2. sp_detach_db @dbname = 'dbname'
3. Copy the database files to the new location
4. sp_attach_db @dbname = 'dbname', @filename1 = 'path\data_filename' , @filename2 = 'path\log_filename'

Hope this helps.

 

[tlbroadbent]

FrontPage connects to SQL Server not the physical location of the files. It wwill work just fine. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.