 | |
Offline Backup
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Offline Backup -
04-21-2004
, 08:40 AM
#2
| |||
| |||
|
#3
| |||
| |||
|
|
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 (AT) aa (DOT) com> wrote in message news:Od5%23jb6JEHA.2884 (AT) TK2MSFTNGP12 (DOT) 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? |
#4
| |||
| |||
|
|
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 (AT) aa (DOT) com> wrote in message news:Od5%23jb6JEHA.2884 (AT) TK2MSFTNGP12 (DOT) 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? |
#5
| |||
| |||
|
|
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 (AT) aa (DOT) com> wrote in message news:e6oCG$6JEHA.3292 (AT) TK2MSFTNGP11 (DOT) 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 (AT) dont (DOT) spam.me.cips.ca>, iletide sunu yazdi news:ua6RHj6JEHA.952 (AT) TK2MSFTNGP12 (DOT) 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 (AT) aa (DOT) com> wrote in message news:Od5%23jb6JEHA.2884 (AT) TK2MSFTNGP12 (DOT) 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? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.