• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

Making MS SQLServer database available 7/24

What are the tools and methods that are needed to make SQLServer database available 7 by 24 with switchover capability?
0
Threshold1
Asked:
Threshold1
1 Solution
 
odessaCommented:
if you use some defined accounts on NT Server you can modify work time for this accounts whitch can use database, or by SQL Executive to schedule stoping and starting to the server
0
 
david_levineCommented:
You don't need to do anything to make it 24x7. You actually have to do something to make it not 24x7. As far as switchover... what are you looking for? Automated switchover? Manual switchover? Any downtime possible (manual recovery). An automated failover is expensive and complicated. Let me know and I'll try to help.
0
 
achopraCommented:
To begin with if you want to deploy SQL for a 7x24 capability with failsafe switchover capability begin with the OS.
You will require WolfPack, and should be running Enterprise edition of NT.
Thereafter decide wether you want  single disk array or mirrored arrays, and install SQL Server on the cluster (Enterprise Edition. In the event you are using mirrored arrays, you may need to configure SQL to comitt simultaneously to both systems, rather than relying on the file system to do so.

i would also strongly reccomend that you wait for SQL 7 to do a full blown 7x24 deployment. It is a lot easier to manage, to begin with.

There are some ocnsiderations regarding the backup, etc dependent upon the applications and size of DB as well.

let me know if you need more help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now