July 8, 2013 at 8:59 am
what is the difference between general log file and the log file in replication ?
July 8, 2013 at 10:22 am
First, if this is interview/homework, please identify it.
Second, you should do some research yourself. There is a lot of documentation.
Third, semantically, I'm not sure what you mean. SQL Server has a transaciton log file for each database. There are error logs for various services (database engine, agent, SSIS packages, etc), which are separate and different. Are you looking for an error log file or a transaction log file?
July 8, 2013 at 1:39 pm
Publisher database (I guess you call it General) must be in full recovery model, so txn log will always grow until you will back it up.
Subscriber database must be in simple model, so its txn log will have a size of the largest transaction.
July 8, 2013 at 4:27 pm
SQL Guy 1 (7/8/2013)
Publisher database (I guess you call it General) must be in full recovery model
Not true. Publisher can be in any recovery model
Subscriber database must be in simple model, so its txn log will have a size of the largest transaction.
Not true. Subscriber can be in any recovery model.
There are no recovery model requirements for replication.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply