SQL Fail Over

Posted on 2006-05-18
Medium Priority
Last Modified: 2012-05-05
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
Question by:higgsy
  • 3
  • 2
LVL 50

Expert Comment

ID: 16711101
replication won't guarantee that you don't lose data...
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)


sorry haven't time for anything fuller.
LVL 10

Expert Comment

ID: 16731424
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

Author Comment

ID: 16732535
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

LVL 10

Expert Comment

ID: 16732729
are you using sql 2000 or 2005 .. and what version of sql are you running ? standard or enterprise

Author Comment

ID: 16732746
SQL 2000 standard
LVL 10

Accepted Solution

TAB8 earned 1500 total points
ID: 16732796
The log shipping feature is only available in the Enterprise Edition of SQL Server 2000.
You can build your own homegrown solution by taking a backup of the db's
in question and copying it to another server, then having the logs cut and
copied to the other server and applying the backup and the logs
sequentially. There are some scripts online if you look for "custom
logshipping ". or check out http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question