Member for 5 years, 4 months
Last seen more than a month ago
Runnemede, NJ, United States
For lack of a better description. Model is copied to create new databases. This ensure they have the same collation, size, data growth settings, and any other parameter you want to set.
For me, large growths in MSDB are from adding and deleting the table entries within the backupset tables. Do you have a history purge or anything running?
Yes you can use linked servers, that is one way we handle this. You will need the correct oracle driver installed in order to use it. I would put the opentran on the inserting of the data versus any ...