Replicate Vault DB

[ljj]

Hey There,

Is there anyone who haved tried to replicate the Vault Database from one server to another.??

In our production environment we would like to replicate our primary server to a secondary SQL Server, so we have the date 2 places all the time. I have tried to used the SQL Replication, but with no luck.

Is there anyone who haved tried this, and could give me some help?

Kind regards

Lars Lilja Jensen
ENERGI E2

[jclausius]

Lars:

Sorry, the database cannot be replicated. The requests for this feature has been low, but I've added your name to the list.

[ljj]

Can i use the MS SQL Replication???

/Lars

[lbauer]

Are you wanting to do transactional replication?

It is not possible to do replication with the current Vault database schema. We use encryption, which prevents the trigger from being published as part of SQL Server replication.

As protection, some of the schema, triggers, stored procedures, and user defined functions, are created with the "with encryption" flag."

[LJJ]

Yes, i would really like to use transactional replication.

I tested it yesterday. But i didn't seem to work, now i can't upload files larger than 1mb, Vault Returns the following error msg.

[30-11-2004 08:45:00] Server unavailable for transaction end
[30-11-2004 08:45:00] Transaction failed
[30-11-2004 08:45:00] Item $/Test/VPN-klient-4.0.4b.zip caused the transaction to fail: Could not retrieve the file from the database.
[30-11-2004 08:45:00] Transaction failed

The Replication Setup is as follows.

1. I Copied the Vault db to the secondary server, and then deleted all user tables
2. On the main server i used the guide to set up Transactional Replikation.
3. Then it replicated all the user tables, and when it was done i began to test.

The strange thing is that i can upload 100 kb files whitout any problems.

Kind regards

Lars Lilja Jensen

[LJJ]

Sorry, i wrote som nonsens before, I did not attach the database, i created a new one. So i do not get the Stored Procedures and other information with the replication..

This is a feature that we really want to use... Is there a workaround?

Kind regards

Lars Lilja Jensen

[tcarrico]

It is difficult to replicate ntext in SQL Server. possible, but difficult. the code used to insert and update the text data needs to be written with replication in mind.

What is the purpose of replicating the data? maybe there are other options, such as log shipping.

[ljj]

We need 2nd server, if the primary fails or if the primary needs service. If we have the 2nd server then we will always have a working server....

And we can take out the primary server for longer period for service etc.

With out the work will be interfeered..


Best Regards

Lars