higgsy
asked on
SQL Fail Over
My SQL skills are not the best but i now need to set up replication for failover purposes.
I have a core server with a business critical database which needs to replicate in realtime to a second server. Not bothered about failover just need it to work like disk mirroring so that if i loose a server i instantly have access to that database.
Can anyone talk me through the process in simple terms
I have a core server with a business critical database which needs to replicate in realtime to a second server. Not bothered about failover just need it to work like disk mirroring so that if i loose a server i instantly have access to that database.
Can anyone talk me through the process in simple terms
I disagree ... Clustering will require a SAN, I would use Log shipping , this allows you to easily setup a stanby database 'with no auto failover .. same a replication' without the overhead of replication .... you can set up log shipping to run every 5 minutes ....
or if you goto sql2005 you could look at DB mirroring even better
or if you goto sql2005 you could look at DB mirroring even better
ASKER
Cool how would this be done??? log shipping?? is the the easiest way to failover a database.
A 5 minute delay is not a problem
A 5 minute delay is not a problem
are you using sql 2000 or 2005 .. and what version of sql are you running ? standard or enterprise
ASKER
SQL 2000 standard
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
just that the minimum amount will be lost...
any failover is up to you to control...
you probably also want to read up on Clustering / cluster server(ices)
hth
sorry haven't time for anything fuller.