Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jstormoen
Starting Member
30 Posts |
 Posted - 2006-03-15 : 23:16:34
|
| Alright I was moving my master db using the instructions from microsoft - change the startup parameters and and restart of the service nothing would come back. I believe I must have mistyped something in my startup paramenters - how do I get into SQL to change that if the service won't restart ? |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-03-16 : 06:00:20
|
| Hi, You should be able to move the master DB back to where it was, and start up the server and do it all over again? |
 |
|
|
jstormoen
Starting Member
30 Posts |
Posted - 2006-03-16 : 09:04:30
|
| I had a copy in the original spot but the startup parameters that I changed cause me to not be able to get in EM. Here is what I ended up doing - Since I had full backups of all my DB's I fully rebuilt SQL on that machine restored all the DB's and am in process of recovering users and jobs.Not the best way or the prettiest - I did find out about sqlservr.exe with the -m parameter to start up a single user server - this did me no good though as I could not find that executable in it's appropriate place. I believe this instance had some issues prior to starting this change. |
|
|
|
|
|
|
Master DB move gone wrong -0 help ?