you don’t mind stop the database from working, then you can DETACH it, move the files and then ATTACH it.
- Right click on the name of the database
- Select
Properties - Go to the
Filestab - Make a note of the
PathandFileNameof MDF and LDF files. This step is important in case you don’t want to end up searching for missing files… - Right click on the database name
- Select
Tasks -> Detach - Move the files where you want
- Right click on the
Databasesnode of your server - Select
Attach - Click on the
Addbutton - Point to the new location
- Click
OK
Comments are closed