Dan White
  • Member for 5 years, 4 months
  • Last seen more than a month ago
Changing the default size and AutoGrowth settings for new SQL Server Databases
Accepted answer
4 votes

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.

View answer
Why MSDB transaction log file grew while MSDB was in Simple recovery mode?
1 votes

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?

View answer
Extracting data from people soft db to SQL Server
0 votes

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 ...

View answer