I have a SQL Server 2008 R2 database and I am trying to change the location of the data and log files from the C drive to the D drive.
I have followed the instructions here:
When I create a new database, it correctly created the data and log files in the new location on the D drive. However I was hoping to move the location of an existing database by doing the following:
1. Backup the database
2. Delete the database
3. Restore the database
The problem is when I do the restore it still saves the data and log files in the old D drive location. I am aware there are commands to alter the database etc but I was hoping by doing the restore it would save everything in the new location.