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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error 1073548784 when running backup of trn logs

Author  Topic 

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.2047
Report was generated on "UOPITT".
Maintenance Plan: mp_BackuptTransactionLogs
Duration: 00:00:01
Status: Warning: One or more tasks failed..
Details:
Back Up Database (Transaction Log) (OASIS-DB)
Backup Database on Target server connection
Databases: All user databases
Type: Transaction Log
Append existing
Task 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''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_OSG''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_BM''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_PIBM''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_SOM''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\UOP_NRETNI''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\AMC2''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\AMC_LHCS_DB''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportServer''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportserverTempDB''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportserverNew''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\ReportserverNewTempDB''
GO
EXECUTE master.dbo.xp_create_subdir N''e:\sql server\Data\MSSQL\BACKUP\MSTP''
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
BACKUP 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 = 10
GO
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



nr
SQLTeam MVY

12543 Posts

Posted - 2006-12-12 : 09:53:27
Looks like you have a database that has never had a full backup and are trying to do a tr log backup on it.
Until a full backup is taken the tr log will be truncated on checkpoint and not available for a backup.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

bogey
Posting Yak Master

166 Posts

Posted - 2006-12-12 : 11:21:36
This has been running for months without any problem. I'll dig deeper into this.

Thanks for your quick response.


quote:
Originally posted by nr

Looks like you have a database that has never had a full backup and are trying to do a tr log backup on it.
Until a full backup is taken the tr log will be truncated on checkpoint and not available for a backup.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Go to Top of Page

markoh
Starting Member

1 Post

Posted - 2009-02-23 : 08:20:12
if you remember - what was the couse and solution?
tnx
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-23 : 09:31:58
Solution is you have truncated the chain of log backup with Truncate_only option.Start again with Full Backup.
Go to Top of Page
   

- Advertisement -