July 18, 2003 at 5:42 am
Hi Guys,
I'm just after some advice really.
Well, my crys for a Disaster Recovery plan have been heeded.
I have an SQL database that stores timesheet entries, billing information etc. So it is being accessed constantly. The data is also reported on regularly..from the same server. My current solution (based on lack of funds/servers etc) consists of a full daily backup and hourly transaction backups.
If I could get a second server in place what would be my best option.
1.Standby server with log shipping used for reporting.
2.Clustering
3.Replication
Thanks in advance guys
Graeme
July 18, 2003 at 10:17 am
Here are some thoughts:
Standby and clustering sound good if your server is heavily taxed
Replication sounds good if the primary concern is disaster recovery, this route can also have advantages from a license POV.
A second server might also be an opportunity to better secure the timesheet information. Could be an issue if timesheets are all on an internal network but billing can go outside the network.
Everett
Everett Wilson
ewilson10@yahoo.com
July 18, 2003 at 10:19 am
-- Clustering is too expensive and you must need either Advance server or Data center unless you use some third party tools to setup the cluster
-- I usually go for Log shipping if I need entire database on the standby server and it is strictly for STANDY ONLY
-- Use Replication if you need data only for the specified tables and planning to use as a reporting database
Shas3
July 23, 2003 at 4:08 am
Thanks a lot for that.
Graeme
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply