Link to home
Start Free TrialLog in
Avatar of SQLM_M
SQLM_MFlag for India

asked on

HP NAS

Please advise.

I have 100's of SQL DB Servers in the DataCenter and need to take the database backup in each servers so while checking in the HP Site and they recommended NAS as a solution for my requirement.

Basically, in the daily basis the data would be moved to this NAS system and then data has to be backup up from the NAS to the tape drives.

Whether, this can be achievable like
1) Moving data from 100's servers into the NAS system
2) In the retention Period the data can be moved to the Tape Library from NAS system ?

Can someone give me the design plan for moving to huge data to the Tape library

The tape library slots has to be at-least 12 slots ( Any Such library available from HP/Dell)

Thanks
Avatar of JanEnEm
JanEnEm

What in my view HP means, is the following

Use a proper backup software package to perform, what is called a D2D2T backup solution.
This means periodically (at requirement) 'copy' your data to a different disk volume (usually a network disk, such as, but not necesseraly, a NAS device. At more convenient time the primary backed up data will be copied to tape and (preferably) eventually stored on different premises.

This is in a nutshell the basic backup idea.
Note that there are many, and I really mean a lot, of different scenarios to consider, for which it is best to hire a professional backup recovery consultant to outline a) how to setup your business requirements b) to translate them into technical requirements and c) to translate thaese into a proper backup/recovery solution.

Jan Meijer
Avatar of SQLM_M

ASKER

HP -> www.hp.com

Any best NAS Box available for  having the capicity of 8 TB with connectivity to Tape Library.

In addition, which can be best tool for moving data between NAS and Tape

Please suggest.


Thanks
Hi,

Before jumping into conclusions as to what hardware configuration you could use, I like to emphasize that your backup plan must be the lead to all this.

Are you already running a backup solution? With what software?
If not, dis you decide on the software?

In short also explain:
a) what OS are your databases running under.
b) what database are you using
c) What applications are you running

As to the hardware:
I would suggest to install a iSCSI based storage device with the required capacity (we'll come to that later) and a separate tape lib available over Ethernet (i.e. IP based). Not a NAS device.
But that depends on the source configuration: OS, hardware, Ethernet capable of iSCSI and so on.

Please be more specific as to what configuration is to be secured.

Jan Meijer




Just to make sure what you really need/want:

Copying data from a db-server to the NAS (as you stated) would result in a series of files on the NAS device. securing these files need a backup software solution on a separate backup server. Tpa solutions (stand alone or library) can be attached directly to a NAS device using a NDMP connection , or indirectly over the (dedicated?) LAN.

There could be all in one solutins on the market to bring a solution, but I am not aware of any. So a combined hardware software soltion seems more appropriate to me. As in NAS device, LAN usage, backup server and Tape device (Lib or stand alone)

The latter could be the start of a config to propose.

Jan Meijer
Avatar of SQLM_M

ASKER

Hi Jan,
We are already having a Backup solution with followings.

1) Windows 2003 OS
2) Tape Drive 1 Slot
3) SQL Server 2000/2008
4) Backup Utility for moving the data between the server and Tape

Can you please give me some additinal information about (separate tape lib available over Ethernet)

Thanks,
Moharnaj
SOLUTION
Avatar of JanEnEm
JanEnEm

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How are you doing the backup, with SQL's inbuilt backup under a maintenance plan or through something like Backup Exec SQL agents? That makes a big difference on the design.

If you use SQL then backup to a remote UNC and then have a tape library on that is what HP are suggesting, that's pretty straight forwards, you can buy an X1500 G2 NAS box and since it runs Windows you can install normal backup software on it such as Backup Exec.

You can also use the same hardware with remote agents but there is also the option to use a virtual library system for the disk staging area, this achieves better compression than standard D2D2T because the virtual library de-duplicates the virtual tapes. Virtual tape library costs a lot because of the cost of the de-duplication software.
Avatar of SQLM_M

ASKER

Hi Andy & Jan,

Thanks for guiding.

Having few more doubts in this.

Like, X1500 This is NAS Box, are there any related product for Tape Library in same HP products ?

1) Can you please share the TapeLibrary for HP (atleast 12 Slots)

2) In X1500, Microsoft Windows Storage Server 2008 Standard x64 Edition has any application for scheduling the data to Tape Drives. (Eg. Veritas )

Thanks,
Mohanraj Jayaraman
MSL2024 ought to do, http://h18000.www1.hp.com/products/quickspecs/13258_div/13258_div.html LTO5 model has 6Gb SAS version. It comes with HP Data Protector Express Basic backup and recovery software which is enough to backup the server so it will backup any local files including any that the SQL servers have backed up to through UNC.

HP don't do HBAs but suggest the P212/zero to put in the NAS server to connect to the library, it's listed in quickspecs above. You may also need an expansion shelf of disks for the X1500 G2, you don't say how much data there is to be backed up. You might also need two drives in the library, again I can't tell without knowing how much data there will be per day.

Avatar of kevinhsieh
I suggest a dedupe appliance that you can backup to, and can also coordinate with the backup software for moving data to tape and keeping that all catalogued. Look at EMC/DataDomain, Quantum DXi, ExaGrid, FalconStor, etc. I don't think that a basic NAS target that doesn't have any intelligence in terms of dedupe or integration with backup software makes much sense unless you are just trying to do it on the very cheap.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SQLM_M

ASKER

Received Collective information from everyone and got it what i want it.

Thanks to Everyone who have given support for choosing me a design for my requirement.