bogey
Posting Yak Master
166 Posts |
Posted - 2006-12-12 : 09:37:51
|
We are getting an error when running a maintenance plan to backup our transaction logs each 15 mins. Here is the output from the log:We are getting the same error code when running a maintenance plan to backup our transaction logs. Here is the output from the log:Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2047Report was generated on "UOPITT".Maintenance Plan: mp_BackuptTransactionLogsDuration: 00:00:01Status: Warning: One or more tasks failed..Details:Back Up Database (Transaction Log) (OASIS-DB)Backup Database on Target server connectionDatabases: All user databasesType: Transaction LogAppend existingTask start: 12/12/2006 9:30 AM.Task end: 12/12/2006 9:30 AM.Failed:(-1073548784) Executing the query "BACKUP LOG [MSTP] TO DISK = N'e:\\sql server\\Data\\MSSQL\\BACKUP\\MSTP\\MSTP_backup_200612120930.trn' WITH NOFORMAT, NOINIT, NAME = N'MSTP_backup_20061212093002', SKIP, REWIND, NOUNLOAD, STATS = 10" failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup.BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Command:EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\Staging''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_OSG''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_BM''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_PIBM''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_SOM''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_NRETNI''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\AMC2''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\AMC_LHCS_DB''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportServer''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportserverTempDB''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportserverNew''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportserverNewTempDB''GOEXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\MSTP''GOBACKUP LOG [Staging] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\Staging\Staging_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''Staging_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [UOP_OSG] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\UOP_OSG\UOP_OSG_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''UOP_OSG_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [UOP_BM] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\UOP_BM\UOP_BM_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''UOP_BM_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [UOP_PIBM] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\UOP_PIBM\UOP_PIBM_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''UOP_PIBM_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [UOP_SOM] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\UOP_SOM\UOP_SOM_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''UOP_SOM_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [UOP_NRETNI] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\UOP_NRETNI\UOP_NRETNI_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''UOP_NRETNI_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [AMC2] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\AMC2\AMC2_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''AMC2_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [ReportServer] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\ReportServer\ReportServer_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''ReportServer_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [ReportserverNew] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\ReportserverNew\ReportserverNew_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''ReportserverNew_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10GOBACKUP LOG [MSTP] TO DISK = N''e:\sql server\Data\MSSQL\BACKUP\MSTP\MSTP_backup_200612120930.trn'' WITH NOFORMAT, NOINIT, NAME = N''MSTP_backup_20061212093002'', SKIP, REWIND, NOUNLOAD, STATS = 10 |
|