I am an Arcserve user since version 6. I have had lots of problems with the Raima/VLDB, moreso as my database has grown. Now, when my database grows to nearly 4GB or so, my jobs will fail upon attempting to merge into the database. My only resolution is to re-initialize the database. This is a pain. Here are my questions:
1) I don't want to buy a SQL license, can I use MSDE instead?
2) If I move to a bigger, better, faster server will my problems with this database subside?
3) What exactly does pruning remove from the db? Doesn't seem to do much for us. What's a good rule (or rules) of thumb for pruning?
Any help is much appreciated!!!