Backup Failed but backup file is created

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Backup Failed but backup file is created

24 posts, Page 1 of 3

1 2 3 »»»

Backup Failed but backup file is created

Rate Topic

Display Mode

Topic Options

Author

Message

namdinh4

Posted Monday, February 25, 2013 1:50 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 10, Visits: 56

Hey guys,

I have an issue with backing up a 80GB database over the network,
Here is the error:A nonrecoverable I/O error occurred on file "\\yyy\xxx.BAK" 64(The specified network name is no longer available.). BACKUP DATABASE is terminating abnormally.

I know it is network related issue but the backup file (xxx.bak) is created on directory (\\yyy).
I checked the backupset table on the server, that i backed up the database from, and verified that there is no entry related to (\\yyy\xxx.bak). I think it means that the database server does not recognize this backup file (xxx.bak) on directory (\\yyy)
I was doubting the integrity of the backup file, so I verify the file by using Restore Verifyonly; the result comes back: the backup file is valid.
I restored the backup file (xxx.bak) to a different database, and I was successfully restore that database to different server.

Here is my question:
How can the backup file is created when the backup command is terminated?

Thanks in advanced.

Post #1423768

Patrick_Fiedler

Posted Monday, February 25, 2013 3:09 PM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:46 AM
Points: 244, Visits: 470

Hi,

have you first checked the backup with restore headeronly?
Occurs the error on every backup?

Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de

Post #1423789

namdinh4

Posted Monday, February 25, 2013 3:33 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 10, Visits: 56

Yes I have.
I checked the file already using headeronly, filelistonly, and verifyonly. There is no issue with the file. The fact that i was able to restore that file on another server proving that the file is valid.

Post #1423798

Lynn Pettis

Posted Monday, February 25, 2013 3:40 PM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:17 PM
Points: 21,617, Visits: 27,450

Is this a native backup or are you using third party software to compress the backup?

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1423800

namdinh4

Posted Monday, February 25, 2013 3:46 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 10, Visits: 56

It is a native backup. I use SSIS script job to fire the backup command.

Post #1423804

Patrick_Fiedler

Posted Monday, February 25, 2013 5:35 PM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:46 AM
Points: 244, Visits: 470

On which Type of device you are backing up?

Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de

Post #1423829

namdinh4

Posted Monday, February 25, 2013 5:41 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 10, Visits: 56

I backed up the database on a share folder. The media is raid 5 disks.

Post #1423830

Patrick_Fiedler

Posted Monday, February 25, 2013 11:40 PM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:46 AM
Points: 244, Visits: 470

Have you tried to backup the Database on a local Drive? Is there the Same error?

Has the SQL Service Account Full Control of this Share?

Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de

Post #1423892

david.alcock

Posted Tuesday, February 26, 2013 4:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 03, 2013 2:25 AM
Points: 115, Visits: 450

Have you restored to a test server and ran CHECKDB on the restored database?

'Only he who wanders finds new paths'

Post #1424009

namdinh4

Posted Tuesday, February 26, 2013 7:23 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 10, Visits: 56

yes, everything is good. I could not figure out why the file is there when the backup command is terminated.

Post #1424075

« Prev Topic | Next Topic »

24 posts, Page 1 of 3

1 2 3 »»»

Permissions