|
We use both methods but the deciding factor only comes
down to whether our clients (app owners) want to pay for the SQL license or not.
Our DBA are happy eitherway, and during our DR excercises earlier this year we
had no problems with restoring DB's backed up using the sql agent.
We implement our online agent using the same process
Simon described below.
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
|
This email (including any attachments) is confidential. If you are not the intended recipient you must not copy, use, disclose, distribute or rely on the information contained in it. If you have received this email in error, please notify the sender immediately by reply email and delete the email from your system. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects. Lend Lease may monitor incoming and outgoing emails for compliance with its Email Policy. Please note that our servers may not be located in your country.
| 