Expertos,

I have encountered a problem while running through this procudere to move
model and msdb:

##############################################################

To move the MSDB database on SQL Server 2000, follow these steps:




1.

In SQL Server Enterprise Manager, right-click the server name and

click Properties.

2.

On the General tab, click Startup Parameters.

3.

Add a new parameter as "-T3608" (without the quotation marks).


After you add trace flag 3608, follow these steps:




1.

Stop, and then restart SQL Server.

2.

Make sure that the SQL Server Agent service is not currently running.

3.

Detach the msdb database as follows:

use master

go

sp_detach_db 'msdb'

go


4.

Move the Msdbdata.mdf and Msdblog.ldf files from the current location

(D:\Mssql8\Data) to the new location (E:\Mssql8\Data).

5.

Remove the -T3608 trace flag from the startup parameters box in

Enterprise Manager.

6.

Stop and then restart SQL Server.

7.

Reattach the msdb database as follows:

use master

go

sp_attach_db

'msdb','E:\Mssql8\Data\msdbdata.mdf','E:\Mssql8\Data\msdblog.ldf'

go

################################################################




After step 4 I want to go into the properties for the server in order to
remove the Trace3608 flag but I get the following error:

Error 22528: [SQL-DMO] This Server Connection has been unexpectedly broken
and can not be reconnected...

Could anyone please provide insight into troubleshoting this...

thanks....

Luis


MS Sql Server LazyDBA home page