Hi
This might sound like a stoopid question but how do i move a database to a different location. It is currently on the C drive and i want it to be on the E drive
Thanks
Right click on your database name in Enterprise Manager. Choose All tasks from the menu and then Detach from the submenu. Move your files to desired location. Right click on the word Databases (your database disappeared from the list of databases by the way)
in EM. Choose All Taska again and then choose Attach. Enter the location/name of your .mdf (data file) and the name of the database it should be attached to and click OK. You should be back in business in your new location.
I would try this process with a test database first just to make sure you have it cause you do lose your database until you attach again.
PS: I left out one mouse click. You have to click the verify button if you type in the name of the location of your data file to activate your OK button. If you use the browse feature you don't cause it verifies when you chose the file.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.