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.
