Solved

Change SQL Startup Parameters

Posted on 2007-11-26
6
1,316 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
  • 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

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…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now