Re: [Veritas-bu] MS SQL 2005 Backups
2007-07-11 02:34:45
Hi Chris
I
may need to chat to you about the logs, because I do backup and truncate logs
once a day - I guess it depends on the business and their expectations on
"restore" or DR if something goes wrong.
Like you, not had any problems with it, and if you have the chance
and time to do it, I would say go for it.
Heck.... trial it and still do disk backups via SQL (using the
built in SQL tool) at the same time until the DBA is happy with the online
backups.
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 Daniel,
I have been at different companies and have done MS SQL Backups
to tape through NBU and I would highly recommend it. I have found it
much faster than backing up files from disk. I currently would recommend
using a combination of Full, Differential, and Log backups on DB's that are in
full recovery mode. You can skip the Diff backups on smaller DB's and
just do Fulls daily. I think log backups every hour has been a standard
at most of the companies I have worked for.
-- Chris Wible
>
Message: 3 > Date: Tue, 10 Jul 2007 10:38:38 -0700 > From:
"Jimenez, Daniel" > Subject: [Veritas-bu] MS
SQL 2005 Backups > To: veritas-bu AT mailman.eng.auburn DOT edu >
Message-ID: >
>
Content-Type: text/plain; charset="us-ascii" > > 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. &! gt;
> > > Daniel Jimenez > > Backup and
Recovery > > -------------- next part -------------- >
An HTML attachment was scrubbed... > URL: >
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070710/1e3736fe
> /attachment.htm > > ------------------------------
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
|
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|