Backup Exec 12.5 for SQL Backups, nothing Else?

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » Backups » Backup Exec 12.5 for SQL Backups, nothing...

25 posts, Page 3 of 3

Backup Exec 12.5 for SQL Backups, nothing Else?

Expand / Collapse

Author

Message

Posted Thursday, November 05, 2009 10:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, November 16, 2009 11:28 AM
Points: 1,268, Visits: 1,912

A couple comments here:

1. BE can do all kinds of DB backups. They have very good documentation about how to set it up and optimization for SQL backups. Google it for your environment/version. DBA should know how to use it as a user and SQL host as a client for backup/restore.

2. Tape does not necessary mean physical tape nowadays. It could be virtual tape library/storage (consolidation, fast I/O…). Media is a better word to describe the backup destination on my own opinion. Backup set then goes to the physical tape sooner or later.

3. Network admin may be trying to introduce the new technology to your workshop. Work with him/her first and try out the pros/cons and let the facts speak themselves.

4. Vendor support tech forum may give you some clues about the existing problems and support quality.

5. You can speak as a DBA, but this is not a simple technical or a DBA preferred decision.

Post #814391

Posted Saturday, November 07, 2009 7:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 7,471, Visits: 7,030

I'd not recommend it for the reasons already mentioned.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #815406

Posted Saturday, November 07, 2009 11:10 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:23 PM
Points: 1,956, Visits: 4,261

2. Tape does not necessary mean physical tape nowadays. It could be virtual tape library/storage (consolidation, fast I/O…). Media is a better word to describe the backup destination on my own opinion. Backup set then goes to the physical tape sooner or later.

Agreed, This is an area where these tools have moved forward, tape does not mean tape anymore, so reliability is much better. Still means some expensive hardware you need to buy and a longer recovery time.

4. Vendor support tech forum may give you some clues about the existing problems and support quality.

this is another part of the problem with entrusting your backup and recovery to a tool. there is a huge user base for the native tools and any situations you find yourself in someone else is likely to have hit before and there are solutions on the net. That won't be so much the case with tools. I even find the error codes out of redgate somewhat obtuse (there I said it).

5. You can speak as a DBA, but this is not a simple technical or a DBA preferred decision.

can you explain that one Vivien, when is database backup and recovery not a preferred DBA decision?

Post #815458

Posted Monday, November 09, 2009 11:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, November 16, 2009 11:28 AM
Points: 1,268, Visits: 1,912

george sibbald-364359 (11/7/2009)

can you explain that one Vivien, when is database backup and recovery not a preferred DBA decision?

For this case, when/if BE can better benefit the organization.

Backup strategy involves SLA, process, cost, auditing, etc. It is more than a simple technical decision or DBA can decide own his/her own (unless in a small company where DBA wears many titles).

My point is there are many backup options available. DBA should be open to these new technologies and different ways of doing DBA work.

Post #815993

Posted Monday, November 09, 2009 11:52 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:08 PM
Points: 939, Visits: 3,628

i've been using Netbackup for almost 10 years now and have been managing it for 3-5 years in addition to being a DBA. it's very easy to learn, very easy to set up. speed depends on the tape tech you are using. we're on LTO-4 which maxes out at 700GB per hour per tape drive. LTO-5 is coming next year which doubles that and double the capacity to 1.6TB/3.2TB raw and compressed. with LTO-4 i'm actually seeing a lot of tapes hold 3TB of data. i thought it was a mistake and asked about this on the Netbackup forums and people said that it's normal and that they advertise on the lower end of the performance envelope. for the server we have a cheapo HP Proliant DL 380 G5. you can't use anything less since the I/O of the server will determine your backup speed.

we looked at SAN client backups for Netbackup, but it was too expensive and with 10 gigabit ethernet getting very cheap and very fast I/O servers that came out this year it doesn't make sense.

just make sure you use the SQL agent for backups, don't backup your databases as an NT backup

Post #816012

« Prev Topic | Next Topic »

25 posts, Page 3 of 3

Permissions

Expand / Collapse