Solved

Change SQL Startup Parameters

Posted on 2007-11-26
6
1,319 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 208R2 not recognizing DBF file in linked Server 11 60
how many extra RAM for SQL server is needed 22 43
Help with SQL - TOP 10 by date and by group 13 40
Sql query 107 73
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 …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 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