Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-01-22 : 15:30:02
|
| I am trying to setup a database which has minimum down time. Are my following recommendations right?Microsoft SQL Server replication technology is recommended to minimize the down time for AICMS system. Transaction repliction where all the transactional changes - DMLs on the publisher database are monitored and are published to the Subscriber - another SQL Server instances. This synchronization happens whenever there is any transactional changes in the Publisher database. It is required that Publisher and Subscriber are reliably and/or frequently connected through the network.Should I also take into backup and recovery plan mentioned belowThe following backup and recovery plan is also recommended on the premise that the database is set to 'FULL' recovery modelThe database and transaction log must be backed up using an SQL Agent as part of maintenance plan (or tape agent i.e. SQL Agent)Should the above plan be sufficient to start with - for 24 X 7 system with minimum downtimeAny suggestions and inputs would helpThanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-22 : 16:52:10
|
| Doubt it.You probably want to look at clustering and maybe load balancing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-23 : 02:34:43
|
| "minimum downtime"How long a period of unscheduled downtime is acceptable?Kristen |
|
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-01-23 : 09:10:19
|
99.9% of year it should be up and runningquote:
Originally posted by Kristen
"minimum downtime"How long a period of unscheduled downtime is acceptable?Kristen
|
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-24 : 04:47:09
|
| That gives you (on average) 1.44 minutes per day.....I'd say you're looking at a lot of 24/7 weeks in order to gain yourself some "usable service intervals". And also you're looking at using very experienced SQL DBA's who can plan, design (and implement) this environment.And possibly needing a complete dual set of hardware in order to practice the timings of these "service internals"...like patches, new hardware, etc!! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-24 : 09:54:26
|
| Doesn't sound like you are in the right area with your initial post for that sort of availability.If I were you I would quickly say that I didn't have the experience to design this on my own - otherwise you are not likely to end up with a reasonable solution and could spend a lot of money on it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Minimum Down time