Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1328
  • Last Modified:

Change SQL Startup Parameters

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
novicedbaUK
Asked:
novicedbaUK
  • 3
  • 2
1 Solution
 
SvenTech Lead Web-DevelopmentCommented:
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
 
novicedbaUKAuthor Commented:
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
 
SvenTech Lead Web-DevelopmentCommented:
Have you tried running sql server in single user mode and then detaching the database?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
novicedbaUKAuthor Commented:
That is what this extra parameter is for


-c -m -T3608

Unfortunately this does not seem to do the trick
0
 
YveauCommented:
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
 
novicedbaUKAuthor Commented:
Many thanks for that link. I was having a problem with master database but have successfully moved it. Regards
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now