3rd party backup/restore

I'm looking for recommendations for 3rd party backup/restore software for
SQL Server 2000.
The software must be cluster aware. Ease and speed of recoverability are
most important. I am not so concerned with compression ratio but rather the
ease of which junior staff could restore databases at crunch time. Point in
time restore is essential.
thanks to any one who could offer an opinion.A follow-up if I may. Do any of these products allow you to recovers users
at the server level when a restoring a database to a different server. It's
a hassle scripting and transferring logins.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
the
> ease of which junior staff could restore databases at crunch time. Point
in
> time restore is essential.
> thanks to any one who could offer an opinion.
>|||"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
>
Any particular reason you can't use the built in backup tools for SQL Server
2000?
In any case, I'd recommend Litespeed for SQL Server.

> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||I am very happy with the price, the speed, and the ease of restores and
backups using RED GATE. Instead of bak sizes of 80+ gig, they are about 10
gig. Its a great piece of software.
--
Regards,
Jamie
"Terri" wrote:

> A follow-up if I may. Do any of these products allow you to recovers users
> at the server level when a restoring a database to a different server. It'
s
> a hassle scripting and transferring logins.
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
> the
> in
>
>|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
>
> "Terri" <terri@.cybernets.com> wrote in message
> news:f1vj1k$teb$1@.reader2.nmix.net...
for[vbcol=seagreen]
> Any particular reason you can't use the built in backup tools for SQL
Server
> 2000?
I'm hoping it would be easier for an administrator to make a timely restore.
The performance boost can't hurt.

> In any case, I'd recommend Litespeed for SQL Server.
Thanks for your response, I'll take a look.|||"Terri" <terri@.cybernets.com> wrote in message
news:f2070q$2i9$1@.reader2.nmix.net...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message
> news:OURUS2ykHHA.3484@.TK2MSFTNGP02.phx.gbl...
> for
> Server
> I'm hoping it would be easier for an administrator to make a timely
> restore.
> The performance boost can't hurt.
Easier?
Can't say I ever found
RESTORE DATABASE FOO from file="backup.bak" with NORECOVERY
all that complex :-)
But.. the performance boost is definitely a plus.

>
> Thanks for your response, I'll take a look.
>|||Are Red Gate and Lightspeed cluster aware? Also, can those products restore
to a server on which the product does not reside?
Terri, if you REALLY want ease/speed of recoverability, get familiar with
the backupset system table and create a restore database script that takes a
parameter of @.DBName and creates all necessary RESTORE statements to
completely recover a database. Holy-Shit time is NOT the time to be
futzing with an interface you aren't familiar with. I used such a mechanism
(albeit a BIT more complex and hand-crafted at crunch time) earlier this
year to restore 719 databases having 6 backup files each to two different
servers in about 4 hours total time. :-O
TheSQLGuru
President
Indicium Resources, Inc.
"Terri" <terri@.cybernets.com> wrote in message
news:f1vj1k$teb$1@.reader2.nmix.net...
> I'm looking for recommendations for 3rd party backup/restore software for
> SQL Server 2000.
> The software must be cluster aware. Ease and speed of recoverability are
> most important. I am not so concerned with compression ratio but rather
> the
> ease of which junior staff could restore databases at crunch time. Point
> in
> time restore is essential.
> thanks to any one who could offer an opinion.
>