Change SQL Startup Parameters
Posted on 2007-11-26
There is a need for me to move the system databases from the C drive to a different drive. I am currently testing this on a test machine. We are using SQL 2005 Standard Edition
I have done the following:
1.Stopped SQL Server Agent
2.Used advanced tab on configuration manager and typed the following: -dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-c -m -T3608 (I have added the last entry to start it with trace flag 3608)
When I detach the model db I get an error message cannot detach system databases
What am I doing wrong?