System error 1453 during database backup, while 2

• jostorero

  SSC Veteran

  Points: 295

  More actions

  September 14, 2003 at 6:30 am

  #159878

  Hi,

  I'm running Sql-Server 2000 standard edition with sp3 (8.00.760)

  I have the following error :

  BackupMedium::ReportIoError: write failure on backup device 'C:\Program

  Files\Microsoft SQL Server\MSSQL\BACKUP\master.bak'. Operating system error

  1453(error not found).

  while performing a backup of any database in Enterprise Manager or in a

  scheduled job.

  This error only occurs when my 2 instances are started.

  I have no quota limitations on my server and both instances are started

  under system account.

  As every one experienced this problem ?

  Best Regards,

  Jerome

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  September 15, 2003 at 2:15 am

  #474135

  May help a bit

  http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=2089

  From the thread

  quote:

  ---

  We replaced:

  "D:\DB\BackupFolder"

  with

  \\Servername\d$\DB\BackupFolder

  ---

  

• jostorero

  SSC Veteran

  Points: 295

  More actions

  September 15, 2003 at 1:31 pm

  #474236

  Thank's for your answer. It seems to work for the backup.

  Unfortunately, I found the same error in the errorlog. This error occured during the normal use of the db (DTS package inserting datas in tables)

  Here is the portion of the errorlog :

  2003-09-15 15:27:12.21 spid3 LogWriter: Operating system error 1453(error not found) encountered.

  2003-09-15 15:27:12.23 spid3 Write error during log flush. Shutting down server

  2003-09-15 15:27:12.23 spid69 Error: 9001, Severity: 21, State: 1

  2003-09-15 15:27:12.23 spid69 The log for database 'aboware_filanosa' is not available..

  2003-09-15 15:27:12.24 spid69 Error: 9001, Severity: 21, State: 1

  2003-09-15 15:27:12.24 spid69 The log for database 'aboware_filanosa' is not available..

  2003-09-15 15:27:12.26 spid69 Error: 3314, Severity: 21, State: 4

  2003-09-15 15:27:12.26 spid69 Error while undoing logged operation in database 'aboware_filanosa'. Error at log record ID (16314:2217:19)..

  2003-09-15 15:27:12.26 spid69 Error: 9001, Severity: 21, State: 1

  2003-09-15 15:27:12.26 spid69 The log for database 'aboware_filanosa' is not available..

  2003-09-15 15:27:12.26 spid69 Error: 3314, Severity: 21, State: 4

  2003-09-15 15:27:12.26 spid69 Error while undoing logged operation in database 'aboware_filanosa'. Error at log record ID (16314:2217:19)..

  2003-09-15 15:27:12.26 spid69 Error: 9001, Severity: 21, State: 1

  2003-09-15 15:27:12.26 spid69 The log for database 'aboware_filanosa' is not available..

  2003-09-15 15:27:12.26 spid69 Error: 3314, Severity: 21, State: 5

  2003-09-15 15:27:12.26 spid69 Error while undoing logged operation in database 'aboware_filanosa'. Error at log record ID (16314:1175:1)..

  2003-09-15 15:27:13.31 spid16 Starting up database 'aboware_filanosa'.

  2003-09-15 15:27:14.51 spid16 Analysis of database 'aboware_filanosa' (9) is 100% complete (approximately 0 more seconds)

  2003-09-15 15:27:14.54 spid16 Recovery of database 'aboware_filanosa' (9) is 0% complete (approximately 4 more seconds) (Phase 2 of 3).

  2003-09-15 15:27:17.29 spid16 Recovery of database 'aboware_filanosa' (9) is 69% complete (approximately 1 more seconds) (Phase 2 of 3).

  2003-09-15 15:27:17.29 spid16 132 transactions rolled forward in database 'aboware_filanosa' (9).

  2003-09-15 15:27:17.29 spid16 Recovery of database 'aboware_filanosa' (9) is 69% complete (approximately 1 more seconds) (Phase 3 of 3).

  2003-09-15 15:27:17.37 spid16 Recovery of database 'aboware_filanosa' (9) is 100% complete (approximately 0 more seconds) (Phase 3 of 3).

  2003-09-15 15:27:17.37 spid16 2 transactions rolled back in database 'aboware_filanosa' (9).

  2003-09-15 15:27:17.39 spid16 Recovery is checkpointing database 'aboware_filanosa' (9)

  Thanks for your help

  JO

  Edited by - jostorero on 09/16/2003 02:43:18 AM