Solved

Change SQL Startup Parameters

Posted on 2007-11-26
6
1,318 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
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.

 

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.

Question has a verified solution.

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

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…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

809 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