I have moved the model database by using following method
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' )
- Stop the instance of SQL Server to perform maintenance.
- Move the file or files to the new location.
- Restart the instance of SQL Server or the server.
While restarting instance of server i am getting following error as shown below.
"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."
How to solve this error?