Real Time Transactional Logging/Backup & Real Time Data Replication 1

[bundyld]

Hello all,

I have a question. My work is currently running a SQLServer7 Database and we process Insurance Claims. I need to find a tutorial or help with Real Time Data Replication for sql server 7, where if a transaction is made or a column is updated it will replicated that information out from our production server to our backup server? Any help with this will be greatly appr. Any help at all, just get me pointed in the right direction.

Thank You,
Lance Bundy
MIS
The Commerce Group


if(money!>0)
{
WorkMore();
}
else if(money > 0)
{
PayBills();
BillsAmount++;
WorkMore();
}

 

[bundyld]

Also... I know that you can use SQL Server 7's Replication feature, but... we have tables that are greater than 100 columns.

Is there any way to get around the limit on # of columns set by the Replication feature or, another way to replicate the data?

Thank You.

 

[SQLSister]

You could put triggers on each table to manage this, but I don't know what kind of a performance hit you will take. And you will have to make sure the triggers can handle multiple records or you may create a serious problem.

 

[bundyld]

SQLSister see below.

Ok, I have figured that I am going to do it by using the Transaction Log that is built automatically through Enterprise Manager. Solves the first half of my question.

Now my question becomes, how can I use the transaction created by Enterprise Manager to Replicate those transactions to our backup servers DB? Can I just set a schedule on DTS that grabs that transact file? or do I have to build a program that will write it out to that server? Any help from here is welcome.

Thank You,
Lance Bundy
MIS
The Commerce Group

SQLSister: thank you for responding, Unfortunatly I don't think we want to go down that road due to having a splitscreen editing site for the claims and our database holds thousands of Images of claims that have been scanned. Can't afford many chances on performance hits. lol

 

[SQLSister]

Look up log shipping in Book Online, that might help you.

 

[bundyld]

Thank you SQLSister. You have been very helpfull. This is exactly the help I was looking for.

Thanks Again, I might questions once I actually get into the business of implementing but until then. Thank you.

Lance Bundy
MIS
The Commerce Group.