Solved

Change SQL Startup Parameters

Posted on 2007-11-26
6
1,320 Views
Last Modified: 2012-08-13
Hello

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?
0
Comment
Question by:novicedbaUK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Sven
ID: 20349552
There are a number of websites explaining how to move databases correctly:

http://support.microsoft.com/kb/224071
http://www.cryer.co.uk/brian/sqlserver/howto_movedatabasefile.htm

or simply google for "move sql database"
0
 

Author Comment

by:novicedbaUK
ID: 20349564
It annoys me when I get answers saying look on Google. That is the place I look at first!!!!!!! I have also visited Microsoft's website and followed the instructions but still getting the same error
0
 
LVL 11

Expert Comment

by:Sven
ID: 20349587
Have you tried running sql server in single user mode and then detaching the database?
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:novicedbaUK
ID: 20349636
That is what this extra parameter is for


-c -m -T3608

Unfortunately this does not seem to do the trick
0
 
LVL 18

Accepted Solution

by:
Yveau earned 125 total points
ID: 20349997
Here is a very good description of what you want.
Sorry, it's a link again, but I cannot retype the whole site as that is against the EE regulation.

http://msdn2.microsoft.com/en-us/library/ms345408.aspx

Hope this helps ...
0
 

Author Closing Comment

by:novicedbaUK
ID: 31410961
Many thanks for that link. I was having a problem with master database but have successfully moved it. Regards
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Two tables - Sum of values - What is the difference 31 56
Unable to save view in SSMS 21 81
Need help how to find where my error is in UFD 6 47
Database maintenance 36 108
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question