winmansoft (4/8/2013)
I have moved the model database by using following method1. For each file to be moved, run the following statement.
ALTER DATABASE model
MODIFY FILE ( NAME = modeldev , FILENAME = 'G:\model\model.mdf' )
ALTER DATABASE model
MODIFY FILE ( NAME = modellog , FILENAME = 'G:\model\modellog.ldf' )
2. Stop the instance of SQL Server to perform maintenance.
3. Move the file or files to the new location.
4. Restart the instance of SQL Server or the server.
Nothing wrong with the sequence itself, however, you must check that the SQL Server service account has permission to read\write the folder
G:\model\
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉