What is "best strategy for the following scenario" | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

What is "best strategy for the following scenario"

Hi,<br /><br />I need guidance for the following scenario.<br /><br />We are shifting our database server from our vendor location to in-house, but what I found they have divided our database into 3 different databases<br /><br />DB1 (images)=120 GB<br />DB2 (text based)=45 GB<br />DB3 (images)=56 GB<br /><br />I tried to restore DB2 at my development computer, it was real pain in my neck when I restore this database (it took me like 4-6 hours).<br /><br />This server is business critical, and I am going to have a standby database server ready (in case if primary server go down I can use this backup server).<br />I have SQL 2000 Standard license for both servers.<br /><br />I would like to know<br /><br />1- What procedure I put in place to make sure my both servers are properly replicating. <br />I have not done any replication procedure before and reading around for replication possibilities. I have read about Clustering (it require Enterprise Server) and find it troublesome, I have also read about log shipping and think it will be more easier than Clustering. I am really not sure and will need feed back from you guys.<br />2- Which technique I can put in place for backup (if I am going to perform full backup every night, it is going to kill my server for number of hours).<br />3- I still have 2-3 weeks before we bring our server in-house, so I still have bit of time to find different strategies.<br /><br />Will appreciate assist from experts here [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />].
if you config the storage per my rec in the other post, with emphasis on the 2 extra raid controllers plus the embedded controller, ie, 6 scsi channels, and 4 disks per channel on the plug-in, 2+ per on the embedded, the backup should run at 400MB/sec+, so total of 200GB backup, 3DB, should take 10min,
use LiteSpeed to do a compressed backup, the next minor version will have improved restore times.

Joe, You are killing me with your valuable answers [8D].
I am going to purchase my DELL server as per your advise, I don’t have enough funds else I engage you for my setup [:I].

if the dell rep asks why don’t you go for a shiny new SAN instead of DA storage, tell them what you hear on this site its time they own up to the fact they are pushing grossly overpriced HW,
that performs like crap as far as sequenital IO goes

Joe, I would like to check, how much it can cost me to prepare the server if I follow the setup you have suggested?
what do you mean by prepare the server?
i will probably make some sql scripts available to test the disk
Mean BUY, sorry for Vague word.
its on the Dell website PE 2800, 1 dual core, 4GB $3,000
2nd dual core 1,000
PERC 4/DC + 7 add 73G 10K 3,000
additional controllers $800 each
PowerVault 220S, red pwr sup
8 73G 10K disks 6,000 so you are probably looking at 22K, i think you will have to call Dell, becuase the online does not let me pick the 2×4 internal drive cage config personally, for external storage, i have been buying the Supermicro cases
$450 for 2×4 disks, additional 1×4 at ~$250, scsi cables $200
12 disks at $180 each, so 3K per 12 ext disks PE2800 + 2 white box storage = $15K

Hi Joe, You said 10 drives at 180$ each.
Where i can get these drives and what is the type of warrenty?