best way to backup SQL2005 Database

vista2008 — Sat, 16 Feb 2008 18:33:51 GMT

Hi,

I am new to Snapshot backup technology. We have a EVA4100 for our SQL2005 DB server storage,LUN(D:) for log and LUN(E:) for DATA.
I am planning to do daily snapshot to backup the data & log as below:

1. use sqlserver built-in backup to perform backup DB & log to another LUN(F:) in SAN
2. create snapshot for LUN F:
3. present the snapshot to another win2003 hosts for tape backup

I am not sure if I am making the best use of snapshot. Could someone tell me what is best practice to backup SQLserver using snapshot ?

Thanks in advance!

ML

Re: best way to backup SQL2005 Database

Patrick Terlisten — Sun, 17 Feb 2008 08:05:24 GMT

Hello,

the best practise for a SQL backup is certainly "Data Protector Zero Downtime Backup fÃ¼r HP EVA Disk Arrays". But if you don't use Data Protector fÃ¼r you backups, you can't use it.

IMHO is doing a backup with the built-in backup utilities, snapshooting the volume and presenting the volume to the backup host one step to much.

Try snapshotting the sql volume directly. Check the product site fÃ¼r EVA Business Copy (http://h18006.www1.hp.com/products/storage/software/bizcopyeva/).

But remember: Business Copy is an additional feature for which you have to pay. It's licensed in form of LTU (License to use) and terabytes.

Hope this helps.

Best regards,
Patrick

topic best way to backup SQL2005 Database in Disk Enclosures

best way to backup SQL2005 Database

Re: best way to backup SQL2005 Database