Viewing 2 posts - 1 through 2 (of 2 total)
If you are going with detach and attach the database no need to stop and start the sqlservices. But if you want change the path using ALTER DATABASE scripts( mentioned...
December 15, 2009 at 10:19 pm
#1092802
1. For each file to be moved, run the following statement.
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path\os_file_name'...
December 15, 2009 at 5:02 am
#1092443