Saturday, February 25, 2012

Moving MSDB to new location in SQL2000--Urgent

HI all,
what is best way to move msdb to new loctaion (from F to E drive)on the
same system in sql server2000?
Shall I use restore command instead of attaching and detaching...
Thanks in advance..
SuchiI believe that KB 224071 has explicit instructions for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:F096E1C9-CDDF-4A6B-BFA2-62415245E612@.microsoft.com...
> HI all,
> what is best way to move msdb to new loctaion (from F to E drive)on the
> same system in sql server2000?
> Shall I use restore command instead of attaching and detaching...
> Thanks in advance..
> Suchi
>

No comments:

Post a Comment