Unsolved
This post is more than 5 years old
2 Posts
0
300
August 22nd, 2008 07:00
Where the replication manger history is kept?
My goal is to provide users with a SQL table that tells them when the replication manager mounted a new copy of our production database (to our reporting server). Can I read directly from replication manger or have replication manger run a post script to write the data to table? I just don't know where the replication manger history is kept...
Any suggestions would be appreciated.
Any suggestions would be appreciated.
No Events found!
JamesBEMC
257 Posts
0
August 25th, 2008 05:00
Many ways of doing this, I think the best would be to do the following;
Setup a post-mount script for each job to write the relevent information of the mounted SQL Dbs in that job to a file (on a network share) and then use a central script to collect the information from those files in order to build the table you need to provide to the users.
Cheers
James