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
I 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
>
Showing posts with label loctaion. Show all posts
Showing posts with label loctaion. Show all posts
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
>
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
>
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
>
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
>
Subscribe to:
Posts (Atom)