Skip to Content
0
Former Member
Jan 03, 2008 at 01:52 PM

Backup error SQL - Help me

474 Views

I error with the backup of SQL, whenever agendo the backup in the DB13, he returns with the error below:

  • Task history information ***********

For run: 20071223 20:00:00

Status: 0 (failure) (see DB error log)

Message: 3013

Severity: 16

Duration: 1 hour, 48 minutes, 3 seconds

Last msg: Executed as user: ANTILHAS\Administrator. ...DBCC

printed error messages, contact your system admini

strator. [SQLSTATE 01000] (Message 2528) Processe

d 3468800 pages for database 'PRD', file 'PRDDATA1

' on file 1. [SQLSTATE 01000] (Message 4035) Proc

essed 3287880 pages for database 'PRD', file 'PRDD

ATA2' on file 1. [SQLSTATE 01000] (Message 4035)

Processed 3337560 pages for database 'PRD', file '

PRDDATA3' on file 1. [SQLSTATE 01000] (Message 403

5) Processed 3392000 pages for database 'PRD', fi

le 'PRDDATA4' on file 1. [SQLSTATE 01000] (Message

4035) Processed 1879 pages for database 'PRD', f

ile 'PRDLOG1' on file 1. [SQLSTATE 01000] (Message

4035) BACKUP DATABASE successfully processed 134

88119 pages in 6395.229 seconds (17.277 MB/sec). [

SQLSTATE 01000] (Message 3014) Cannot open backup

device 'prd_full'. Device error or device off-lin

e. See the SQL Server error log for more details.

[SQLSTATE 42000] (Error 3201) VERIFY DATABASE is

terminating abnormally. [SQLSTATE 42000] (Error 30

13). The step failed.

Here is the Log SQL:

2007-12-23 21:48:06.64 spid134 BackupDiskFile::OpenMedia: Backup device '
alaska\e$\prd_full.BAK' failed to open. Operating system error = 32(The process cannot access the file because it is being used by another process.).

2007-12-23 21:48:06.64 spid144 BackupMedium::ReportIoError: read failure on backup device '
alaska\e$\prd_full.BAK'. Operating system error 64(The specified network name is no longer available.).

2007-12-23 21:48:06.64 spid144 Internal I/O request 0x2CE53928: Op: Read, pBuffer: 0x00000000, Size: 94, Position: 51019212887767344, RetryCount: 753218864, SubIoCount: 753218880, UMS: Internal: 0x0, InternalHigh: 0x0, Offset: 0x2BD40578, OffsetHigh: 0x2CE539A0, m_buf: 0x2CE539A8, m_len: 1, m_actualBytes: 0, m_errcode: 64, BackupFile: n/a 2007-12-23 21:48:06.64 backup BACKUP failed to complete the command BACKUP DATABASE [PRD] TO [prd_full] WITH INIT , NOUNLOAD , NAME = N'prd_full', SKIP , STATS = 10, NOFORMAT DECLARE @i INT select @i = position from msdb..backupset where database_name='PRD'and type!='F' and backup_set_id=(select max(backup_set_id) f2007-12-23 21:50:23.14 spid144 BackupDiskFile::OpenMedia: Backup device '
alaska\e$\prd_full.BAK' failed to open. Operating system error = 64(The specified network name is no longer available.).

Someone I know what I can do to solve this problem?

Thanks

Edited by: Ademir de Souza on Jan 3, 2008 2:52 PM