With that being said, here's what it does:
Similar to what you can do with CL Copy on a command line, it will create a replica on another server, but it does it with full directories and a bunch of options you can turn on.
In the setup document, you specify target servers and what directories to scan. You also set the following options:
- Create replicas (via AdminP or immediate) of all databases in the directory if they don't already exist
- If your target replica database quota is different from the source, make the target quota the same as the source
- Turn on LZ1
- Turn on Document Compression
- Turn on on DAOS
- Turn on Transaction Logging
- Upgrade ODS (you need the appropriate notes.ini file changes made)
- Create full text index if one exists on source
The agent then:
- Checks for differences between two replicas on different servers and displays it all in a report document
- Number of documents
- Access Control List
- Full Text Index type and last date it was indexed
- Last Fixup Date
- Quota
- On Disk Structure
- Document compression
- LZ1 compression
- Unread marks
- Transaction logging
- DAOS status
- % Whitespace
- ...and a few others.
- Automatically creates new replicas for each database in the directory if a replica is not found on the target server. For example, you have an Archive policy and your archive database gets created on new user registration, however you need to manually create the replica, assign the quota, etc. This utility can be scheduled to run every week so that you can be sure your archive directory is always in sync with the replicated directory on another server.
There are a couple of status bugs I'm working on, but for all intents and purposes, it keeps my databases in sync (especially for quotas) and helps me ensure they have the properties I want. I also spot replication problems with that report. If you have any suggestions or you customize it a bit, please let me know so I can implement those changes too.
Here's the link to download.
And if you like it and use it, let me know by commenting below.
Good stuff!! Can it create a copy instead of a replica?
ReplyDeleteNo, but I'm sure that could be worked in relatively easily.
ReplyDeleteSteve, I would like to point to this in my UKLUG session as a resource if that is ok. let me know.
ReplyDeleteChris
Sure Chris, be my guest!
ReplyDeleteI haven't tested the code, however, if it really does everything in that list, I'm pretty impressed. Good job.
ReplyDeleteYou da man Steve! :-D
ReplyDeleteLooks like a awesome little tool. Just one question. I have setup and configured everything like I wanted to for a test. Now how do I run it?
ReplyDeleteIt's a scheduled agent. Pick whatever time you want to have it run in the agent properties.
ReplyDelete