Backup of transaction log disappears

Hi All
I have this weird problem, and i cant find out what is happening.
I have a a database maintence plan that backsup the transaction log for one
of our databases. The job runs, i watch the trn file get created, then when
the job is complete, the trn file disappers, and the job fails becasue it
cannot open the log file to verify the backup.
I have no idea where the trn files are going.
here is the DBmaintance log file.
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'VIRTUAL1\SHAREDSQL' as '****\****' (trusted)
Starting maintenance plan 'riverred Log Backup' on 04/08/2005 7:27:03 AM
[1] Database riverred: Transaction Log Backup...
Destination: [G:\riverred\Log File Backups\riverred_tlog_200504080727.TR
N]
** Execution Time: 0 hrs, 0 mins, 11 secs **
[2] Database Riverred: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Cannot open backup device 'G:\riverred\Log Fil
e
Backups\reiverred_tlog_200504080727.TRN'. Device error or device off-line.
See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE i
s
terminating abnormally.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'Riverred Log Backup' on 04/08/2005 7:27:14 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
SQL2000 with SP3a - in a w2k cluster environment
Any ideas?
thx in advanceHi
Run the backup from T-SQL and see if it also occurs. Check your retention
period of dumps in the maintenace plan.
Regards
Mike
"David" wrote:

> Hi All
> I have this weird problem, and i cant find out what is happening.
> I have a a database maintence plan that backsup the transaction log for on
e
> of our databases. The job runs, i watch the trn file get created, then whe
n
> the job is complete, the trn file disappers, and the job fails becasue it
> cannot open the log file to verify the backup.
> I have no idea where the trn files are going.
> here is the DBmaintance log file.
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'VIRTUAL1\SHAREDSQL' as '****\****' (trusted)
> Starting maintenance plan 'riverred Log Backup' on 04/08/2005 7:27:03 AM
> [1] Database riverred: Transaction Log Backup...
> Destination: [G:\riverred\Log File Backups\riverred_tlog_200504080
727.TRN]
> ** Execution Time: 0 hrs, 0 mins, 11 secs **
> [2] Database Riverred: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Cannot open backup device 'G:\riverred\Log F
ile
> Backups\reiverred_tlog_200504080727.TRN'. Device error or device off-line.
> See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'Riverred Log Backup' on 04/08/2005 7:27:14 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> SQL2000 with SP3a - in a w2k cluster environment
> Any ideas?
> thx in advance
>|||We tried to run it via t-SQL and it didnt work, The retention period is set
for 2 days. I have tried changing the times as well.
D
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Run the backup from T-SQL and see if it also occurs. Check your retention
> period of dumps in the maintenace plan.
> Regards
> Mike
> "David" wrote:
>|||"David" wrote:

> Hi All
> I have this weird problem, and i cant find out what is happening.
> I have a a database maintence plan that backsup the transaction log for on
e
> of our databases. The job runs, i watch the trn file get created, then whe
n
> the job is complete, the trn file disappers, and the job fails becasue it
> cannot open the log file to verify the backup.
> I have no idea where the trn files are going.
> here is the DBmaintance log file.
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'VIRTUAL1\SHAREDSQL' as '****\****' (trusted)
> Starting maintenance plan 'riverred Log Backup' on 04/08/2005 7:27:03 AM
> [1] Database riverred: Transaction Log Backup...
> Destination: [G:\riverred\Log File Backups\riverred_tlog_200504080
727.TRN]
> ** Execution Time: 0 hrs, 0 mins, 11 secs **
> [2] Database Riverred: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Cannot open backup device 'G:\riverred\Log F
ile
> Backups\reiverred_tlog_200504080727.TRN'. Device error or device off-line.
> See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'Riverred Log Backup' on 04/08/2005 7:27:14 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> SQL2000 with SP3a - in a w2k cluster environment
> Any ideas?
> thx in advance
>|||We just moved the log file backup to a different drive. and it works.
Now i am scared about why those trn files were disappearing on the other
drive?
any ideas?
"David" wrote:
[vbcol=seagreen]
> We tried to run it via t-SQL and it didnt work, The retention period is se
t
> for 2 days. I have tried changing the times as well.
> D
> "Mike Epprecht (SQL MVP)" wrote:
>|||What does "didn't work" mean? Can you post the BACKUP LOG command? Also, wha
t error messages did the
backup command return?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David" <David@.discussions.microsoft.com> wrote in message
news:F142C1A1-26D7-4597-93A0-0635C61861B8@.microsoft.com...[vbcol=seagreen]
> We tried to run it via t-SQL and it didnt work, The retention period is se
t
> for 2 days. I have tried changing the times as well.
> D
> "Mike Epprecht (SQL MVP)" wrote:
>|||Hi
There might be something that is deleting the files. It might be a
housekeeping job that someone wrote, setup and forgot to stop.
Try giving the SQL Service account only read/write access to the directory,
and everyone else, read only. Run the backups and see if they survive.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David" <David@.discussions.microsoft.com> wrote in message
news:A31659E5-BFED-4516-B8EA-89C1D96B9691@.microsoft.com...[vbcol=seagreen]
> We just moved the log file backup to a different drive. and it works.
> Now i am scared about why those trn files were disappearing on the other
> drive?
> any ideas?
> "David" wrote:
>|||Sorry, didnt work meant, i recieved the error message, Error, 22029
"Tibor Karaszi" wrote:

> What does "didn't work" mean? Can you post the BACKUP LOG command? Also, w
hat error messages did the
> backup command return?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:F142C1A1-26D7-4597-93A0-0635C61861B8@.microsoft.com...
>
>|||That error doesn't exists in the sysmessages table. Can you post the error t
est? And the BACKUP LOG
command?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David" <David@.discussions.microsoft.com> wrote in message
news:388D6FDC-AA7F-4244-8C83-0D1832D185E5@.microsoft.com...[vbcol=seagreen]
> Sorry, didnt work meant, i recieved the error message, Error, 22029
>
> "Tibor Karaszi" wrote:
>|||I moved the backup destination to another drive, then the maitanence plan
started to work, after 1 day of working properly i am exhibiting the same
problem.
I can see the trn file get created with 0kb then i see the size of the file
appears then the whole trn file disappears.
I tried making a new maitanence plan as well, and get the same problem.
error messages for the job
18204 :
BackupDiskFile::OpenMedia: Backup device
'H:\SQLServer\redriver_tlog_200504152131
.TRN' failed to open. Operating
system error = 32(The process cannot access the file because it is being use
d
by another process.).
3041 :
BACKUP failed to complete the command BACKUP LOG [AbsolutePoker] TO DIS
K =
N'H:\SQLServer\redriver_tlog_20050415213
1.TRN' WITH INIT , NOUNLOAD ,
NOSKIP , STATS = 10, NOFORMAT
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'redriver Log Backup'' (0x6A757F003EBDCD4DB810F28061D0AAE2) - Status: Failed
- Invoked on: 2005-04-15 21:31:50 - Message: The job failed. The Job was
invoked by User domain\administrator. The last step to run was step 1 (Step
1).
Maintanence plan history:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'H:\SQLServer\redriver_tlog_200504152131
.TRN'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE i
s
terminating abnormally.
"Tibor Karaszi" wrote:

> That error doesn't exists in the sysmessages table. Can you post the error
test? And the BACKUP LOG
> command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:388D6FDC-AA7F-4244-8C83-0D1832D185E5@.microsoft.com...
>
>