November 3, 2009 at 8:01 am
Hi all
SQL Server 2005 sp3 on Windows 2003 sp2. database in full recovery mode, full back has been ok, ran low on disk space causing backup to fail. i deleted file to free up space on C: drive. Full back fails but log file backsup fine.
Microsoft was unable to figure this out. Any ideas would be appreciated.
Processed 252648 pages for database 'Store146', file 'Store901_Data' on file 1.
Msg 3202, Level 16, State 2, Line 1
Write on "c:\DB_Backups\store146.bak" failed: 1(Incorrect function.)
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
2009-11-03 06:48:26.52 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2009-11-03 06:48:26.61 spid12s Starting up database 'msdb'.
2009-11-03 06:48:26.61 spid13s Starting up database 'Store146'.
2009-11-03 06:48:26.76 spid9s CHECKDB for database 'model' finished without errors on 2009-11-02 22:00:03.530 (local time). This is an informational message only; no user action is required.
2009-11-03 06:48:26.78 spid9s Clearing tempdb database.
2009-11-03 06:48:27.95 spid12s CHECKDB for database 'msdb' finished without errors on 2009-11-02 22:00:03.797 (local time). This is an informational message only; no user action is required.
2009-11-03 06:48:30.30 spid9s Starting up database 'tempdb'.
2009-11-03 06:48:31.12 spid9s CHECKDB for database 'tempdb' finished without errors on 2009-11-02 22:00:03.530 (local time). This is an informational message only; no user action is required.
2009-11-03 06:48:32.15 spid12s The Service Broker protocol transport is disabled or not configured.
2009-11-03 06:48:32.18 spid12s The Database Mirroring protocol transport is disabled or not configured.
2009-11-03 06:48:32.38 spid12s Service Broker manager has started.
2009-11-03 06:48:34.83 spid13s CHECKDB for database 'Store146' finished without errors on 2009-11-02 22:00:05.873 (local time). This is an informational message only; no user action is required.
2009-11-03 06:48:34.86 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2009-11-03 06:48:34.86 spid5s Recovery is complete. This is an informational message only. No user action is required.
2009-11-03 06:48:36.30 spid51 Using 'xpsqlbot.dll' version '2005.90.4035' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2009-11-03 06:48:36.65 spid51 Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2009-11-03 06:48:36.72 spid51 Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2009-11-03 06:54:47.44 spid56 Error: 18210, Severity: 16, State: 1.
2009-11-03 06:54:47.44 spid56 BackupMedium::ReportIoError: write failure on backup device 'c:\DB_Backups\store146.bak'. Operating system error 1(Incorrect function.).
2009-11-03 06:54:47.48 Backup Error: 3041, Severity: 16, State: 1.
2009-11-03 06:54:47.48 Backup BACKUP failed to complete the command BACKUP DATABASE Store146. Check the backup application log for detailed messages.
2009-11-03 07:21:36.37 spid56 Error: 18210, Severity: 16, State: 1.
2009-11-03 07:21:36.37 spid56 BackupMedium::ReportIoError: write failure on backup device 'c:\temp\store146.bak'. Operating system error 1(Incorrect function.).
2009-11-03 07:21:36.37 Backup Error: 3041, Severity: 16, State: 1.
2009-11-03 07:21:36.37 Backup BACKUP failed to complete the command BACKUP DATABASE Store146. Check the backup application log for detailed messages.
2009-11-03 07:37:11.35 Backup Log was backed up. Database: Store146, creation date(time): 2009/10/01(11:07:01), first LSN: 26541:58149:1, last LSN: 26544:129764:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB_Backups\Store146\Store146_backup_200911030737.trn'}). This is an informational message only. No user action is required.
2009-11-03 07:40:47.99 spid56 Error: 18210, Severity: 16, State: 1.
2009-11-03 07:40:47.99 spid56 BackupMedium::ReportIoError: write failure on backup device 'c:\temp\store146.bak'. Operating system error 1(Incorrect function.).
2009-11-03 07:40:47.99 Backup Error: 3041, Severity: 16, State: 1.
2009-11-03 07:40:47.99 Backup BACKUP failed to complete the command BACKUP DATABASE Store146. Check the backup application log for detailed messages.
BackupMedium::ReportIoError: write failure on backup device 'c:\temp\store146.bak'. Operating system error 1(Incorrect function.).
November 3, 2009 at 8:09 am
My guess is that you have some problem with your disk. Since the log backup is smaller then the full backup, when you are running the log backup, the server is not trying to write anything on the bad part of the disk. On the other hand when you are running the full backup, the server tries to write something on a bad sector on the drive. I would ask the system guys to run a diagnostic check on the disk/storage. Have to admit that this is just a hunch and not something that I’m sure about.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 3, 2009 at 8:42 am
I am leaning that way to as check disk failed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply