SQL Server Performance Forum – Threads Archive

Service not starting after MSDB, Model move

I am trying to move the msdb and model log files to a new location. I entered -T3608 as a startup parameter, stopped and restarted mssqlserver (sql server agent is not running). Within query analyzer I detached both msdb and model. Then removed -T3608 and stopped mssqlserver. When attempting to start mssqlserver I get the message: "The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service." How do I resolve?

---

Hi,
I am about to go through the same process and found this link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 for moving both model and MSDB, it says you need to reattach the model first, and do some other things before detatching too (activate trace flags…) Let me know if the process in the doc works! (save me some heartache if it doesnt!) Ben

---

You can start SQL server in single user mode. From a command prompt, enter:
sqlservr.exe -c -m http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_startp_4okl.asp
Try again to attach msdb and model databases..read carefully below given links first and findout what you missed previously: – http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 http://www.sqlservercentral.com/columnists/chedgate/movingsystemdatabasesachecklist.asp http://www.databasejournal.com/features/mssql/article.php/3379901 Deepak Kumar –An eye for an eye and everyone shall be blind

---

]]>