June 27, 2011 at 10:43 pm
Hello. I have a project where I need to have a failover database system from our current Production Database. Here are the details below:
1. I have about 8 databases that need to be sync with a failover database system. Their are records inserted by users from 8:00am -5:00pm in two databases.
2. I have a Catalog Directory of images on the file system. Their are currently 53 folders with 10,000 images each. I need to sync with a failover database system.
3. I am familiar with Log shipping, Replication, Clustered environment, and Database Mirroring.
I am interested in anyone's expert advice. If any further questions let me know. Thanks.
June 28, 2011 at 12:33 am
Are u using filestream for the catalog directory ?
If so this might help
June 28, 2011 at 2:59 am
What are your downtime and data-loss SLAs?
What's the budget for DR?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2011 at 3:42 am
June 28, 2011 at 9:59 am
No I am not using filestream. We have a Web page that inserts the image into the corresponding directory folder. Should I use filestream to sync images with new database server for failover?
June 28, 2011 at 10:02 am
Thanks for responding. Our budget is tight, but we want high availability and redundancy. We want minimal downtime if our main production server crashes.
What are your downtime and data-loss SLAs?
What's the budget for DR?
--------------------------------------------------------------------------------
June 28, 2011 at 1:16 pm
manning20 (6/28/2011)
No I am not using filestream. We have a Web page that inserts the image into the corresponding directory folder. Should I use filestream to sync images with new database server for failover?
Probably not , esp since these are just images and there might not be a need to maintain some kind of transaction integrity with other data being inserted into the database.
File system backups should server the purpose of DR for these images.
June 28, 2011 at 1:54 pm
manning20 (6/28/2011)
Thanks for responding. Our budget is tight, but we want high availability and redundancy. We want minimal downtime if our main production server crashes.
That's kinda vague.
There are several options available, depends on the requirements, the budget (at minimum you need a second server), the edition and version of SQL and several more.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply