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 |
|
mgole
Starting Member
9 Posts |
 Posted - 2005-03-10 : 19:22:11
|
| HiI have set up log shipping.The backup and restore jobs are working fine.But there are a few errors like 3101 and 3201 in the log_shipping_plan_history table.Also there are some entries in the sql server logs such as"bypassing recovery for database 'xxxxx' because it is marked IN LOADand"BackupDiskFile:OpenMedia:Backup Device 'e:\mssql\hotstandby_log_backup_device'I have set up copy/restore time to 5 min and backup time is also 5 min.I am sending large burst of transactions say 15 transactions/sec (total abt 4000 transactions in one burst)..Are these errors due to low copy/restore time.Should i increase it?ThanksMadhukar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-10 : 19:59:40
|
| Does the log shipping monitor show that the backups, copies, and restores are all working and none of them show the first file still needing to be used?Tara |
 |
|
|
mgole
Starting Member
9 Posts |
Posted - 2005-03-10 : 21:22:41
|
| Yes,log shipping monitor shows the backup,copy and restore are all working.Madhukar |
|
|
|
|
|
|
log shipping errors