Error 3254 – The volume on device BACKUP_PATH is empty

05 June,2013 by Jack Vamvas

The SQL Server message Error 3254 – the volume on device BACKUP_PATH is empty appear appeared in the application logs . What is it ? and how can I analyse?

 Different reason can cause the Error 3254 message to appear. Some suggestions

1) Check for a valid backup set. Use RESTORE VERIFYONLY which checks for

 a)  backup set is present   and header fields of pages

 b) Are volumes readable?

 c)  checksum (if enabled , BACKUP by default does not use CHECKSUM)

 d) destination drive – space check.

For backup header and list of files use Backup file information needed for RESTORE SQL database

 

2) Check for communication failures – which may invalidate the copy.

 

3) Check in Event Viewer for any DNS issues, if file is being backed up to tape or another server

 

4) If the file is being copied – check the source file and target file. If the source file is valid , and the target file is invalid – check communication links, storage devices and other related errors

 

5) Use the Display sql backup history for a single database - SQL Server DBA  to analyse any clues on the backup file

 

Read More

SQL Server faster restores with instant file initialisation

SQL Server – DBCC CHECKDB FAQ - SQL Server DBA

Database stuck RESTORING - SQL Server DBA

Restricted user on database after restore - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Error 3254 – The volume on device BACKUP_PATH is empty


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer