impossible to put msdb db offline

[stanja]

Hello ,

I want to move the file from the msdb database so in order to do that i want to put it offline but it gives the message 'option OFFLINE cannot be set in database msdb'.
I'm using SQL server 2005

grtz
Steven

 

[mutley1]

Steven,

Did you mean you are trying to move the actual data / log files? If so, see:

http://support.microsoft.com/kb/224071

about half way down the page.

Cheers,

M.

 

[stanja]

it 's indeed what i need but is there a possibility to do this without stopping and starting the sql server ?

 

[mutley1]

Not that I know of because the main requirement is the trace flag.

Sorry,

M.

 

[Catadmin]

MSDB is a system database. The reason you can't do it while the database is online is because SQL Server is protecting itself from damage.

It may be annoying, but it is actually a good thing. After all, I wouldn't want some hack coming along and messing with my system DBs (or user DBs) without having to take them offline.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

Wow. There are days where I wish old posts were editable. It is too early in the day for me to communicate with anyone. @=)

What I meant to say about the above is that I'm glad you can't take system DBs offline because someone with malicious intentions could really screw up another person's production environment and crash the production system by the simple act of taking down the Master or MSDB databases.

Does that make sense?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"