Moving model system database on SQL Server 2005

I moved model system database today from default location to E:\SQLData using following steps:

1. NET START MSSQL$LIVE /f /T3608

2. ALTER DATABASE model MODIFY FILE (NAME = modellog, FILENAME = ‘E:\SQLData\modellog.ldf’);

3. ALTER DATABASE model MODIFY FILE (NAME = modellog, FILENAME = ‘E:\SQLData\modellog.ldf’);

4. NET STOP MSSQL$LIVE

5. NET START MSSQL$LIVE

Everything working fine.

Update me when site is updated

Leave a Reply

You must be logged in to post a comment.