Offline Backup

Sorry, this on may be a very easy question for this group but I've to find
the right answer until weekend.. : ))
I should take offline backup at midnight after stopping sql server 2000.
But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
How can I stop my clustered Sql Server and take backup at midnights?
The whole idea of having a cluster is to have high availability. Why can't
you just do regular SQL Server backups?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"aculfa" <aaa@.aa.com> wrote in message
news:Od5%23jb6JEHA.2884@.TK2MSFTNGP12.phx.gbl...
Sorry, this on may be a very easy question for this group but I've to find
the right answer until weekend.. : ))
I should take offline backup at midnight after stopping sql server 2000.
But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
How can I stop my clustered Sql Server and take backup at midnights?
|||Ok, that what clustering means..
But what should I do to stop my Sql Server?
I don't want it to work between some hours let's say..
How can this be done?
Shutting down passive server and stopping Sql Server from the active server
seems a bad solution. Any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca>, iletide sunu yazdi
news:ua6RHj6JEHA.952@.TK2MSFTNGP12.phx.gbl...
> The whole idea of having a cluster is to have high availability. Why
can't
> you just do regular SQL Server backups?
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "aculfa" <aaa@.aa.com> wrote in message
> news:Od5%23jb6JEHA.2884@.TK2MSFTNGP12.phx.gbl...
> Sorry, this on may be a very easy question for this group but I've to find
> the right answer until weekend.. : ))
> I should take offline backup at midnight after stopping sql server 2000.
> But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
> How can I stop my clustered Sql Server and take backup at midnights?
>
>
|||You can use cluster manager to bring the service offline.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"aculfa" <aaa@.aa.com> wrote in message
news:e6oCG$6JEHA.3292@.TK2MSFTNGP11.phx.gbl...
Ok, that what clustering means..
But what should I do to stop my Sql Server?
I don't want it to work between some hours let's say..
How can this be done?
Shutting down passive server and stopping Sql Server from the active server
seems a bad solution. Any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca>, iletide sunu yazdi
news:ua6RHj6JEHA.952@.TK2MSFTNGP12.phx.gbl...
> The whole idea of having a cluster is to have high availability. Why
can't
> you just do regular SQL Server backups?
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "aculfa" <aaa@.aa.com> wrote in message
> news:Od5%23jb6JEHA.2884@.TK2MSFTNGP12.phx.gbl...
> Sorry, this on may be a very easy question for this group but I've to find
> the right answer until weekend.. : ))
> I should take offline backup at midnight after stopping sql server 2000.
> But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
> How can I stop my clustered Sql Server and take backup at midnights?
>
>
|||How can I schedule such a job?
I want to bring Sql Server offline from cluster manager at midnight...
Should I stop cluster service?
"Tom Moreau" <tom@.dont.spam.me.cips.ca>, iletide sunu yazdi
news:%23uwhsD7JEHA.1944@.TK2MSFTNGP10.phx.gbl...
> You can use cluster manager to bring the service offline.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "aculfa" <aaa@.aa.com> wrote in message
> news:e6oCG$6JEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Ok, that what clustering means..
> But what should I do to stop my Sql Server?
> I don't want it to work between some hours let's say..
> How can this be done?
> Shutting down passive server and stopping Sql Server from the active
server[vbcol=seagreen]
> seems a bad solution. Any idea?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca>, iletide sunu yazdi
> news:ua6RHj6JEHA.952@.TK2MSFTNGP12.phx.gbl...
> can't
find[vbcol=seagreen]
MSSQLSERVER"
>