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 |
|
creditwatch
Starting Member
4 Posts |
 Posted - 2004-09-30 : 09:31:19
|
| I am replicating transactions to a backup server. My replication stop with this error. I opened up the Distribution Agent folder and view the details of the Publication in the Agent folder. This is the error I got. The database mydatabase is backed up nightly (full) so I don't understand why this occurred.The log file for database 'mydatabase' is full. Back up the transaction log for the database to free up some log space.(Source: PROD_SRVR2 (Data source); Error number: 9002)Thanks for any help |
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
Posted - 2004-09-30 : 09:45:17
|
| Maybe during the day you had to many transactions and the log size incremented up to the limit. Once you back up da DB the log space is freeIf you make bulk inserts change the type of Recovery Model in the property options of the DB to Bulked-Logged or change the size limit of the log file*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*A candle loses nothing by lighting another candle |
 |
|
|
creditwatch
Starting Member
4 Posts |
Posted - 2004-09-30 : 10:29:13
|
| I backed up the database file. The recovery model is set to Full. The users still have access to the database. The only part that has stopped is the replication piece of the process. That is where the error shows up. |
|
|
|
|
|
|
Full Transaction log shows up in Replication