Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Move Database from C: to E: Running out of space

  Asked By: Roxanne Horton         Date: Dec 18, 2007      Category: Sharepoint      Views: 259
 

I am in a test environment and have moss installed on
a server with sql 2000.
I need to move the content to e drive as c only has 2g
left

how do i do this?

Tagged:                

 

1 Answer Found

 
Answer #1       Answered By: Osvaldo Winters          Answered On: Dec 18, 2007       

Go into SQL Enterprise Manager and detach the databases. move  the MDF files to
E wherever you want them. Then go back into SQL Enterprice Manager and attach
them. Make sure you give them the same names. If you're running  out of space
you might check the size of your log files and move them as well. If your log
files are large you make want to back your databases up and truncate the log
files.

 
Didn't find what you were looking for? Find more on Move Database from C: to E: Running out of space Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].