Thursday, March 8, 2012

database maintenance plan

i am a new to sql server, my question is that can we create database
maintenance plan for those database with offline or detached status.
Thanks
nick
Hi
No. Those DB's are not accessible, so you can not.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:201D8F36-7A07-4989-A58E-C87A91640491@.microsoft.com...
> i am a new to sql server, my question is that can we create database
> maintenance plan for those database with offline or detached status.
>
> Thanks
> nick
|||Nick
No, why do you want to do that? Put the in the safe place.
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:201D8F36-7A07-4989-A58E-C87A91640491@.microsoft.com...
> i am a new to sql server, my question is that can we create database
> maintenance plan for those database with offline or detached status.
>
> Thanks
> nick

No comments:

Post a Comment