Re: [Veritas-bu] MS SQL 2005 Backups
Hey guys
Thanks for taking the time to respond with so many different types of
backup solutions for SQL 2005. I will go through these and any new ideas
that are sent and let you guys know what we chose, thanks again.
Daniel Jimenez
Backup and Recovery
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 11, 2007 7:02 AM
To: Ed Wilts
Cc: Jimenez, Daniel; 'Spearman, David'; 'Haskins, Steve';
veritas-bu@mailman.eng.auburn.edu;
[EMAIL PROTECTED]
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
We have up on the oracle export scenario a couple of years ago. Our
databases became so large that we could no longer
make the backup window. We have been using the Oracle Agent with RMAN,
and with MSSQL as well. We use Maestro, Veritas,
and cron to schedule our RMAN backups and things work quite well.
Hopefully those DBA's will see the light.
=
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
[EMAIL PROTECTED]
"Ed Wilts" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/11/2007 08:46 AM
To
"'Haskins, Steve'" <[EMAIL PROTECTED]>, "'Spearman, David'"
<[EMAIL PROTECTED]>, "'Jimenez, Daniel'" <[EMAIL PROTECTED]>,
cc
Subject
Re: [Veritas-bu] MS SQL 2005 Backups
Ditto. We bought the agents for both Oracle and MS SQL and they still
won't use them. It's caused lots of grief in the past - all issues that
are addressed by the agents - but the DBAs don't want to budge. It's
their butts on the line if the databases have recovery issues though.
.../Ed
--
Ed Wilts, Mounds View, MN, USA
mailto:[EMAIL PROTECTED]
I GoodSearch for Bundles Of Love:
http://www.goodsearch.com/?charityid=821118
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Haskins,
Steve
Sent: Tuesday, July 10, 2007 1:26 PM
To: Spearman, David; Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Same here along with trans logs.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Spearman, David
Sent: Tuesday, July 10, 2007 10:50 AM
To: Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Daniel,
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They
are firm believers in exporting the database(s) to flat files and
backing those up. Don't ask, I don't know why. Suffice to say they are
the DBA's and we just do as we are told.
David Spearman
County of Henrico, Va.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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 ___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This Email message and any attachment may contain information that is
proprietary, legally privileged, confidential and/or subject to
copyright belonging to Pepco Holdings, Inc. or its affiliates ("PHI").
This Email is intended solely for the use of the person(s) to which it
is addressed. If you are not an intended recipient, or the employee or
agent responsible for delivery of this Email to the intended
recipient(s), you are hereby notified that any dissemination,
distribution or copying of this Email is strictly prohibited. If you
have received this message in error, please immediately notify the
sender and permanently delete this Email and any copies. PHI policies
expressly prohibit employees from making defamatory or offensive
statements and infringing any copyright or any other legal right by
Email communication. PHI will not accept any liability in respect of
such communications.
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
We have up on the oracle export scenario a couple of years ago. Our
databases became so large that we could no longer
make the backup window. We have been using the Oracle Agent with RMAN,
and with MSSQL as well. We use Maestro, Veritas,
and cron to schedule our RMAN backups and things work quite well.
Hopefully those DBA's will see the light.
=
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
[EMAIL PROTECTED]
"Ed Wilts" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/11/2007 08:46 AM
To
"'Haskins, Steve'" <[EMAIL PROTECTED]>, "'Spearman, David'"
<[EMAIL PROTECTED]>, "'Jimenez, Daniel'" <[EMAIL PROTECTED]>,
cc
Subject
Re: [Veritas-bu] MS SQL 2005 Backups
Ditto. We bought the agents for both Oracle and MS SQL and they still
won?t use them. It?s caused lots of grief in the past ? all issues that
are addressed by the agents ? but the DBAs don?t want to budge. It?s
their butts on the line if the databases have recovery issues though.
?/Ed
--
Ed Wilts, Mounds View, MN, USA
mailto:[EMAIL PROTECTED]
I GoodSearch for Bundles Of Love:
http://www.goodsearch.com/?charityid=821118
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Haskins,
Steve
Sent: Tuesday, July 10, 2007 1:26 PM
To: Spearman, David; Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Same here along with trans logs.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Spearman,
David
Sent: Tuesday, July 10, 2007 10:50 AM
To: Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Daniel,
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They are
firm believers in exporting the database(s) to flat files and backing
those up. Don't ask, I don't know why. Suffice to say they are the DBA's
and we just do as we are told.
David Spearman
County of Henrico, Va.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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 ___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This Email message and any attachment may contain information that is
proprietary, legally privileged, confidential and/or subject to copyright
belonging to Pepco Holdings, Inc. or its affiliates ("PHI"). This Email is
intended solely for the use of the person(s) to which it is addressed. If
you are not an intended recipient, or the employee or agent responsible for
delivery of this Email to the intended recipient(s), you are hereby notified
that any dissemination, distribution or copying of this Email is strictly
prohibited. If you have received this message in error, please immediately
notify the sender and permanently delete this Email and any copies. PHI
policies expressly prohibit employees from making defamatory or offensive
statements and infringing any copyright or any other legal right by Email
communication. PHI will not accept any liability in respect of such
communications.
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
Ditto. We bought the agents for both Oracle and MS SQL and they still won't use them. It's caused lots of grief in the past - all issues that are addressed by the agents - but the DBAs don't want to budge. It's their butts on the line if the databases have recovery issues though. ./Ed -- Ed Wilts, Mounds View, MN, USA mailto:[EMAIL PROTECTED] I GoodSearch for Bundles Of Love: http://www.goodsearch.com/?charityid=821118 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haskins, Steve Sent: Tuesday, July 10, 2007 1:26 PM To: Spearman, David; Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] MS SQL 2005 Backups Same here along with trans logs. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spearman, David Sent: Tuesday, July 10, 2007 10:50 AM To: Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] MS SQL 2005 Backups Daniel, Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They are firm believers in exporting the database(s) to flat files and backing those up. Don't ask, I don't know why. Suffice to say they are the DBA's and we just do as we are told. David Spearman County of Henrico, Va. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jimenez, Daniel Sent: Tuesday, July 10, 2007 1:39 PM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] MS SQL 2005 Backups 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 ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
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.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of WEAVER,
Simon (external)
Sent: Wednesday, July 11, 2007 2:20 AM
To: 'Jimenez, Daniel'; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
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: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 6:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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.___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
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: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 10, 2007 8:35 PM To: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] MS SQL 2005 Backups 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@mailman.eng.auburn.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/1e37 36fe > /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@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
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: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jimenez, Daniel Sent: Tuesday, July 10, 2007 6:39 PM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] MS SQL 2005 Backups 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___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
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@mailman.eng.auburn.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. > > > > 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 > > -- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
Same here along with trans logs.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Spearman, David
Sent: Tuesday, July 10, 2007 10:50 AM
To: Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Daniel,
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They
are firm believers in exporting the database(s) to flat files and
backing those up. Don't ask, I don't know why. Suffice to say they are
the DBA's and we just do as we are told.
David Spearman
County of Henrico, Va.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
I will not consider exporting and importing data as a backup solution.
You can either use a built in functionality in SQL server to backup the
database to a file then use Netbackup to backup that file. You can use a
combination of SQL agent in Veritas and SQL server backup utility. In
this case, you will have two copies of the database in different format.
Rudy
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Spearman, David
Sent: Tuesday, July 10, 2007 1:50 PM
To: Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Daniel,
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They
are firm believers in exporting the database(s) to flat files and
backing those up. Don't ask, I don't know why. Suffice to say they are
the DBA's and we just do as we are told.
David Spearman
County of Henrico, Va.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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 message (including any attachments) contains confidential
information intended for a specific individual and purpose, and is
protected by law. If you are not the intended recipient, you should
delete this message. Any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly
prohibited.
==
--
This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law. If you
are not the intended recipient, you should delete this message. Any disclosure,
copying, or distribution of this message, or the taking of any action based on
it, is strictly prohibited.
==
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
I feel sorry for you. If you do not have the Veritas adapter for MSSQL,
then it is normally a dump and fs backup of that dump.
Being an DB Engineer, I would question your DBA's DR plan is they are
only doing export dumps.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Spearman, David
Sent: Tuesday, July 10, 2007 10:50 AM
To: Jimenez, Daniel; veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
Daniel,
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They
are firm believers in exporting the database(s) to flat files and
backing those up. Don't ask, I don't know why. Suffice to say they are
the DBA's and we just do as we are told.
David Spearman
County of Henrico, Va.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS SQL 2005 Backups
Daniel,
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They
are firm believers in exporting the database(s) to flat files and
backing those up. Don't ask, I don't know why. Suffice to say they are
the DBA's and we just do as we are told.
David Spearman
County of Henrico, Va.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jimenez,
Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] MS SQL 2005 Backups
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
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] MS SQL 2005 Backups
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 ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
