Backups Best Practices

I have a question about using sqllitespeed.
They say it is faster doing a backup, what about restores,
I have several standby servers that I do full backups on
once in a while, so I don't have to run so many trans
logs. Does it restore fast as well?
Gary

>--Original Message--
>It looks like I have been presented with 2 options for
backing up to tape.
> 1. Use veritas SQL Agent and back up the full every
<blank> days and logs every <blank> days
> 2. Backup using native SQL agent to disk and using
veritas to backup the BAK files to tape every night.
>Anyone have an opinion on which is best and why?
>.
>Yes the restores are generally faster as well.
Andrew J. Kelly
SQL Server MVP
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:116ba01c3f5bb$cd70b130$a101280a@.phx
.gbl...
> I have a question about using sqllitespeed.
> They say it is faster doing a backup, what about restores,
> I have several standby servers that I do full backups on
> once in a while, so I don't have to run so many trans
> logs. Does it restore fast as well?
> Gary
>
> backing up to tape.
> <blank> days and logs every <blank> days
> veritas to backup the BAK files to tape every night.

Backup using SQLLiteSpeed

Gurus,
Has anyone used the product SQL Lite Speed for their
backups? If so, can anyone give me an idea of how the
product is...we are evaluating its use and would like some
industry opinion on it.
Thanks for your help,
SumeshSumesh...
We've recently implemented SQL LiteSpeed on a number of our production and d
evelopment servers. I would highly recommend it to anyone that has large SQ
L databases. We have a ~44Gb database and with SQL LiteSpeed the backup fil
e is under 6Gb!!!! The int
erface is just another MMC snap-in, so it integrates well with Enterprise Ma
nager. Technical Support is VERY responsive and friendly. It's not appropr
iate for SQL Servers that don't house large databases, but for the bigger on
es it's a necessity.
sean|||It works very well, but I came across a few gotchas that I can't
remember right now, I think it was to do with converting maintenance
plans. Anyway, it's probably fixed now. I would highly recommend it, an
excellent product. I have used it on our data warehouse. You need to
switch fiber mode off.
Mark Allison, SQL Server MVP
Sumesh wrote:
> Gurus,
> Has anyone used the product SQL Lite Speed for their
> backups? If so, can anyone give me an idea of how the
> product is...we are evaluating its use and would like some
> industry opinion on it.
> Thanks for your help,
> Sumesh|||Some of my customers also use it, they are extremely excited and happy with
it..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sumesh" <Sumesh.Sundareswaran@.trsga.com> wrote in message
news:fc4b01c40d3b$802ad9e0$a501280a@.phx.gbl...
> Gurus,
> Has anyone used the product SQL Lite Speed for their
> backups? If so, can anyone give me an idea of how the
> product is...we are evaluating its use and would like some
> industry opinion on it.
> Thanks for your help,
> Sumesh