Clustered Sql Server(Again)

I should take offline backup at midnight after stopping our sql server 2000.
But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
(written in MSDN site), also the passive server brings sql server online and
cancels offline backup.
How can I stop my clustered Sql Server and take backup at midnights? How can
I schedule such a job?
(Before clustering we used to write a batch file ("net stop sqlserver") and
in the sceduled tasks we run them whenever needed)
What should I do from now on?
Thanks,
Abdulkadir
First off, offline backups are unnecessary for a SQL Server. You never have
to take a SQL Server offline to back it up. You use the built in backup
features within the product.
As far as interacting with the cluster, you can't do it directly against the
service since that is seen as a failure. You have to stop the SQL Server
through the cluster. I don't know the command, but you issue the equivalent
thing to the cluster and I'm fairly certain the command string can be found
in online help.
But, again, you don't need to shut down a SQL Server to backup the data.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Every night we're taking an online backup, somedays incremental - others
full.
We have another system that backups our SqlServer (Hp Omniback) and this
tool restores DB only to servers which have same collation, same drive name,
same directory,bla bla bla...
We can't restore online backup to any other server we have. We may just want
to restore the files and attach it to any server. At the same time we're
trying that.
Thanks for your answer, I will try to find the command string.
I just wanted to learn how this process is done in other firms...
Thanks again,
"Michael Hotek" <mhotek@.nomail.com>, iletide unu yazd
news:eTD4FLfLEHA.1312@.TK2MSFTNGP12.phx.gbl...
> First off, offline backups are unnecessary for a SQL Server. You never
have
> to take a SQL Server offline to back it up. You use the built in backup
> features within the product.
> As far as interacting with the cluster, you can't do it directly against
the
> service since that is seen as a failure. You have to stop the SQL Server
> through the cluster. I don't know the command, but you issue the
equivalent
> thing to the cluster and I'm fairly certain the command string can be
found
> in online help.
> But, again, you don't need to shut down a SQL Server to backup the data.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>
|||You can use the built-in tools to back up to a local or remote file share.
Then your backup tool can archive those files for disaster recovery. That
way, you get the best of both worlds.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"aculfa" <aaa@.aa.com> wrote in message
news:uVccjcfLEHA.2624@.TK2MSFTNGP09.phx.gbl...
> Every night we're taking an online backup, somedays incremental - others
> full.
> We have another system that backups our SqlServer (Hp Omniback) and this
> tool restores DB only to servers which have same collation, same drive
name,
> same directory,bla bla bla...
> We can't restore online backup to any other server we have. We may just
want[vbcol=seagreen]
> to restore the files and attach it to any server. At the same time we're
> trying that.
> Thanks for your answer, I will try to find the command string.
> I just wanted to learn how this process is done in other firms...
> Thanks again,
> "Michael Hotek" <mhotek@.nomail.com>, iletide unu yazd
> news:eTD4FLfLEHA.1312@.TK2MSFTNGP12.phx.gbl...
> have
> the
Server
> equivalent
> found
>
|||Here is the order in which you would perform your tasks(, from cluster
prespective):
1. Run command "Cluster group <Group Hosting SQL> /offline".
2. Then you are free to perform your SQL related tasks. After you are done
with your tasks make sure that SQL is in the same state as it was after
doing Step1, above.
3. RunCommand "Cluster group <Group Hosting SQL> /online".
Hope this helps.
Sandeep Sutari
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:eTD4FLfLEHA.1312@.TK2MSFTNGP12.phx.gbl...
> First off, offline backups are unnecessary for a SQL Server. You never
have
> to take a SQL Server offline to back it up. You use the built in backup
> features within the product.
> As far as interacting with the cluster, you can't do it directly against
the
> service since that is seen as a failure. You have to stop the SQL Server
> through the cluster. I don't know the command, but you issue the
equivalent
> thing to the cluster and I'm fairly certain the command string can be
found
> in online help.
> But, again, you don't need to shut down a SQL Server to backup the data.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>