| Author |
Topic |
|
dvaddi
Starting Member
21 Posts |
 Posted - 2007-12-14 : 15:39:01
|
| Hi ,I am trying to move the system database master database and mssqlresource database on SQL Server 2005.I am going according to the doc's . And I am logging in as single user mode : NET START MSSQLSERVER /f /T3608 and when I try to login into sqlcmd or Management studio , I get the error:SQL Error 18461 , can not login in more than one administrator server in single user mode.For the managment studio , I close the object explorer as it is taken as one connection and click the new query with existing connection. But it throws me the same error. When I try to enter into sqlcmd , it throws me the same error.What can I do here.. IS there anything I am missing.Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-14 : 22:09:39
|
| Don't have to start sql in single user mode, just need modify startup parameters. Then stop sql, copy db files to new location and restart sql. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
dvaddi
Starting Member
21 Posts |
Posted - 2007-12-16 : 19:39:14
|
| I am able to move the master database.After moving the master database I startup with NET START MSSQLSERVER /f /T3608When I startup in the single user mode to move the mssqlsystemresource i.e to issue the command Alter database mssqlsystemresource ...etc..I get the error that only one administrator can login. Error 18461 I get this error both in Managment studio and sqlcmd.Is there any other way I can do this.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-16 : 20:27:30
|
| You can just copy mssqlsystemresource's files to new location, don't have to start sql in single mode. |
|
|
|
dvaddi
Starting Member
21 Posts |
Posted - 2007-12-19 : 08:50:57
|
| I shutdown the server moved the Master database and also moved the mssqlsystemresoruce and tried starting the SQL Service.But it does not start.When I try to move the mssqlsystemresource database after starting the service it says cannot move as its used.What should I do.Thanks |
|
|
|
dvaddi
Starting Member
21 Posts |
Posted - 2007-12-19 : 09:28:29
|
| Urgent help. I am totally struck.I moved the master database and issed the command for mssqlsystemresource to be in read_only mode and trying to restart the sytem I get the error:System Error 1067The process has terminated unexceptedly.What can I do nowThanks |
|
|
|
dvaddi
Starting Member
21 Posts |
Posted - 2007-12-19 : 12:41:12
|
| Got that working. Did not put the startup parameters properly. |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2007-12-19 : 22:56:37
|
| can u please let me know what startup parameters u specified in order to move sysytem databases. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 00:31:34
|
| Take look at knowledge base article 'How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server'. |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2007-12-20 : 19:19:19
|
| i am talking about system databases attach/dettach works fine for userdatabases but i had difficulty in moving system databases as it gives error database is in use.................. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 19:54:15
|
| That's why you have to follow steps listed in above article. |
|
|
|
|
Error while Moving Master Database