SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup Solutions


Backup Solutions

Author
Message
Stupeo
Stupeo
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 778
Alright,

I need help from SSC members.

I am currently drawing up the hardware specification for the company i work for to provide a TS version of the application we design/develop.

Our solution will compromise of:

1) SQL Server Box (4 x Quad Core procs, 8gb ram, 5 x 146gb Disks in RAID 5)
2) TS Server (4 x Quad Core procs, 16gb ram, 3 x 146gb Disks in RAID 5)
3) Authentication/Web Server (1 x Dual Core Proc, 2 gb ram, 2 x 73gb hdd (RAID 1)

We are happy with the above, but we are looking to implement a backup system also. This would ideally be something removable so we can take backups of site. Im thinking tapes, but havent found any tape drives that can hook up to all three servers? We will need to backup roughly 500gb or data across the 3 servers daily (full backups every night, weekly and monthly).

Any ideas? Or should i be looking at a small scale iSCSI SAN with a single tape backup?

Please help!

Thanks,
Matt.

P.S Sorry about the "Quality" of this post. I am in a bit of a rush at the moment! I will try and revise it later.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: Administrators
Points: 64533 Visits: 19117
Most backup solutions only attach to one server and you send files from other servers to that one, or there is a backup agent that moves files.

Arcserve, Veritsa, BMC, all large backup vendors make software for this. Unless you can afford a high bandwidth offsite link, go with tape.

I'd set up a process to copy data from the SQL box (full, log backups) to one of the other boxes. Perhaps the same thing for the web box and then have tape software move those files to tape.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Stupeo
Stupeo
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 778
Ahh right okay - so that would mean in me tape "host" server, id need to have enough space to cover the other two servers also? Or do any of them packages do compression on the fly,so to speak?

Tar,

Matt.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: Administrators
Points: 64533 Visits: 19117
It would need enough space, but you're not necessarily backing up the entire server. It doesn't really make sense to back up anything other than the database and log backups on SQL Server, so the OS, SQL OS, etc. don't need to be copied over.

On the other server, I'd think you only back up the application/web files, maybe the registrry.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Stupeo
Stupeo
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 778
Nice one Steve, thanks.

Matt.
alen teplitsky
alen teplitsky
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2852 Visits: 4674
i use Veritas and Evault

Veritas we've had for 8 years. we run it on a unix server and have an old Quantum tape robot. we backup 20-30 sql servers and each one has a Veritas agent on it. goes straight to tape with the server controlling everything. we still have old DLT tapes that are 40GB/80GB uncompressed/compressed capacity.

We also started to use Evault and over the next few years will move all the sql backups to it. similar to Veritas except it backs up to disk. uses SQL 2005 Express as it's db engine. you can set it up to have a primary backup volume(s) and then dump to a secondary volume. you can also set up another Evault system at another site and replicate all your backups there. not 100% perfect, but pretty good

we are also looking for a new tape library for now. LTO-4 and it holds up to 1.6T of compressed data per tape
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search