Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

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

  Asked By: Roxanne    Date: Dec 18    Category: Sharepoint    Views: 1965

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

how do i do this?



2 Answers Found

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

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

Answer #2    Answered By: Jack Miller     Answered On: Nov 02

I suggest to not move them manually cause there shall be some hidden files,if you miss something or didnt arrange the file correctly or something bad happends in the moving process,all probably lead to a data loss,or even software collapse.use a partition nanagement software like "MINITOOL partition wizard" to allocate some space from other drivesto C :,very simple.and remember to dont install /download anything necessary to C drive anymore

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.