"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
> 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
> >
> >
>
>

> 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
>
>

"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
>
>