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 |
|
Martyn123
Starting Member
29 Posts |
 Posted - 2010-10-16 : 07:20:25
|
| Hi,I am using SQL Server 2008 and I have three SQL Server instances installed and I am trying to move the model and msdb system databases of only one instance. I have added -T3608;-m;-c startup parameters from configuration manager for that specific instance and I have restarted the service. I have followed the same steps as described in the following link : http://support.microsoft.com/default.aspx?scid=kb;en-us;224071I am getting these error msgs whenever I try to attach and detach the model and msdb databases using sp_detach 'model' and sp_attach_db <<path to mdf and ldf>>. “Cannot detach an opened database when the server is in minimally configured mode” when trying to sp_detach_db ‘model’. *** and the database instance service is getting stopped automatically and soon after that I am getting the following error msg if I try to execute sp_attach_db ."A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)"I don't know why the database instance service is getting stopped automatically.I have checked everything I could ie TCP/IP (enabled),named pipes(enabled),... but nothing worked.Do I need to make any other settings before starting the process?Please reply to this post as early as possible. Thanks in advance.Martyn |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
|
|
|
Error while moving model and msdb system databases