Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup Solutions Expand / Collapse
Author
Message
Posted Wednesday, July 16, 2008 12:29 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 13, 2014 11:32 AM
Points: 939, 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.


Post #535488
Posted Wednesday, July 16, 2008 12:42 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
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
Post #535500
Posted Wednesday, July 16, 2008 1:30 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 13, 2014 11:32 AM
Points: 939, 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.
Post #535532
Posted Thursday, July 17, 2008 9:21 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
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
Post #536091
Posted Thursday, July 17, 2008 9:36 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 13, 2014 11:32 AM
Points: 939, Visits: 778
Nice one Steve, thanks.

Matt.
Post #536112
Posted Thursday, July 17, 2008 11:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 9:36 AM
Points: 1,414, Visits: 4,544
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


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #536175
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse