Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keithc1
Yak Posting Veteran
88 Posts |
 Posted - 2004-07-06 : 00:53:44
|
| I have replication setup for a Database that is set to FULL for recovery model. The Replicated database I noticed also had the FULL option set I assume during the setup of replication.When going through replication setup does the replicated database inherit the settings of the originating database such as the transaction log size at the time of replication? I'm a bit confused as how this works because on the originating database I have FULL model set and log space is 1GB used and I now noticed that on the replicated database the data that was replicated is consistent in size with the originating but the log size is only like 20 MB used but was allocated the size of the originating.Keithc MCSE MCSA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-06 : 16:01:14
|
| The settings were set when the database was created. When a database is created, it uses the model database for a default setup if you don't explicitly tell it what to do.Tara |
 |
|
|
|
|
|
Replication