December 10, 2002 at 3:07 pm
We are preparing to implement log shipping using MS SQL 2000 and I am wondering what particular hardware specifications the "monitor server" will require. Does it need to be a SCSI array or what are everyones recommendations? We will be using ProLiants with RAID 10 for our nodes.
Thanks,
neighborkid
December 10, 2002 at 4:06 pm
Good enough to handle the load if you need to switch to it. No real requirements, there isnt much complicated to log shipping when you get down to it.
Andy
December 11, 2002 at 7:57 am
The monitor server should be resilient enough to not suffer from failure. The level you take this to is up to you, raid, processor, memory, network, etc.
The load I believe isn't great, its just an offsite store to give better restore coverage in the event of the server failing. i.e. if the backup server hasn't updated in 10 minutes then the files will be on the monitor server. (I think)
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
December 11, 2002 at 11:45 am
I will echo the other 2 responses and add that disk space could be an issue. It all depends on the frequency of log dumps, size of each log and retention period.
Be great!
Michael
Be great!
Michael
December 12, 2002 at 2:55 am
Retention is something you will need to consider. If space is an issue then you can use sqllitespeed, which compresses the backups (and can encrypt) saw a demo last week and very very impressed.
Compressed files are also better for log shipping because they can be transfered faster and so you can have a slower (cheaper) link.
Don't try and compress your files with winzip, it will kill your server
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply