Following error appears in the SQL Server error log when I execute BACKUP Log db with truncate_only using a stored procedure. The stored proc I am using is as follows:
CREATE procedure spm_tranlog as
declare @DBName as Varchar(120)
select @DBName = DB_name()
dump transaction @DBName with truncate_only
There are data import processes running in the night, before starting the processes we are executing spm_tranlog procedure to clear the transaction logs. The following error appears in log after executing the spm_tranlog:
¡°BACKUP failed to complete the command exec spm_tranlog¡±
This always happens after weekly server maintenance tasks. The scheduled maintenance tasks I am running are: Index rebuild, truncate log and shrinking database. There were no other processes running during that time when the spm_tranlog prodecure fail.
The Database size is 40GB, Log size is 80MB.
The database is in the simple recovery model.The database is in the simple recovery model.
I am running SQL Server 2000 (SP4) on windows server 2003.
Please help me to resolve this issue.