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 |
|
tad
Starting Member
31 Posts |
 Posted - 2002-06-12 : 09:44:32
|
| My database backs up just fine, but the transaction logs are not. I created a maintenance plan for the database.Any suggestions ?Agent Job for transaction log backupEXECUTE master.dbo.xp_sqlmaint N'-PlanID 0A83F1BC-EEAA-4BDF-9374-E7FF5C1215F8 -Rpt "d:\sqldata\MSSQL$PRODUCTION\LOG\zeon_live_commerce DB Maintenance Plan16.txt" -DelTxtRpt 1WEEKS -VrfyBackup -BkUpMedia DISK -BkUpLog -UseDefDir -DelBkUps 2DAYS -CrBkSubDir -BkExt "TRN"'The error log file for the transaction log backups is...Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ZCHQ_SQL\PRODUCTION' as 'ZCI\SQLSERVICE' (trusted)Starting maintenance plan 'zeon_live_commerce DB Maintenance Plan1' on 6/12/2002 8:15:03 AMBackup can not be performed on database 'zeon_live_commerce'. This sub task is ignored.Deleting old text reports... 1 file(s) deleted.End of maintenance plan 'zeon_live_commerce DB Maintenance Plan1' on 6/12/2002 8:15:03 AMSQLMAINT.EXE Process Exit Code: 1 (Failed) |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2002-06-12 : 10:02:32
|
| If your recovery plan is set to Simple (SQL 2000) or Truncate log on checkpoint (SQL 7.0), then you can't back up the transaction log.To back up the transaction logs, set your recovery plan to Full (SQL 2000) or remove the "truncate log on checkpoint" (SQL 7.0), then create a full database backup. After that, you should be able to back up the transaction log.-- monkey |
 |
|
|
tad
Starting Member
31 Posts |
Posted - 2002-06-12 : 13:38:28
|
It was set to Simple. Thanks for your help.quote:
If your recovery plan is set to Simple (SQL 2000) or Truncate log on checkpoint (SQL 7.0), then you can't back up the transaction log.To back up the transaction logs, set your recovery plan to Full (SQL 2000) or remove the "truncate log on checkpoint" (SQL 7.0), then create a full database backup. After that, you should be able to back up the transaction log.-- monkey
|
|
|
|
|
|
|
db backs up ok, but not trans log