Hello,
In process of installing TFS, I unintentionally installed SQL server on C drive as I could'n see any option of selecting the drives.
Is there any way in which I can move the database folder to another drive without reformatting and going through the same procedure.
TIA
Krisna,
What version of SQL server are you running?
Yes, you can move the DB folders, although SQL server itself will want to stay on the C drive.
Note the names of your user databases, (in the properties of the databases themselves) and then drop them. Then copy/move them to the new location and re-attach.
The system databases (master. model, tempdb and msdb) are a different kettle of fish though. Instructions for moving all databases is here:
http://support.microsoft.com/kb/224071/en-us
No comments:
Post a Comment