|
Hi
Daniel
Well we used to do
the backups to disk, however as we have no "proper" DBA, and administration was
causing some issues (backups failing to write to disk, disk getting full, no
alerts configured, ect) - the online agent was used.
I am recently new to
2005, but this is what I have done...(in short)
1) Configured the
online agent on the master
2) create a policy
using the ms-sql extension
3) configure SQL
Online backups on the client
4) Create a batch
file for all DB's to be backed up
5) Create a batch
file for the backup and truncate the logs (this goes into a seperate policy
BTW)
6) Test /
troubleshoot and prove it works
7) Restore
test.
Now, most DBA's stay
away from online sql backups, claiming its problematic, unreliable. However, on
2 occasions now, NBU has restored SQL from a point in time backup from the DB
and Trans log backup.
Maybe they fear they
will lose their job? We do use SAP / Oracle online agents too, and I can confirm
its very, very good! time saver. However, the DBA's still do DISK backups as
well!
SQL online is
expensive too! Up to you really. Cannot say its right or wrong. I am in the
process of troubleshooting a SQL problem as I write this, and it may be down to
NBU to prove its doing a good job!
anyhow, just my
opinion. HTH
Regards
Simon Weaver
3rd Line Technical Support
Windows
Domain Administrator
EADS Astrium
Limited, B23AA IM (DCS)
Anchorage Road, Portsmouth, PO3
5PU
Email:
Simon.Weaver AT Astrium.eads DOT net
Hey
guys
We are going to start backing up
MS SQL 2005 and I would like to know the best ways to backup this type of
database? Can anyone through their experiences give me their solution and why
they felt it was the best way to do this? I know there is the Veritas way and
that may be the best way of doing these backups but I would like to hear some
alternative ways that may be better than using the Veritas solution, thanks.
Daniel
Jimenez
Backup and Recovery
This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
|
| 