Solved

sqlback up failure

Posted on 2013-12-12
3
256 Views
Last Modified: 2013-12-22
Hi,

I have a couple of databases in a  primary server and I am running maintenance job to backup database (daily at night time)  and transaction logs (every half an hour) to an attached SAS driver. It was working well without any issue.  Yesterday, I have detached the SAS drive from the server and took it to the secondary server for restoring one of my databases, "MyCustDB". After restoring, I have attached the SAS drive back to the primary server. After attaching it, the transaction logs as well as backup started failing with the following reason.  MyCustDB has a Filestream which is created not in the default C: drive of the primary server but in the SAS drive (G:).  The primary filegroup pathis is C: drive but the "FG_MyCust_FS" (filestream) path is G: drive (detachable SAS drive).

Error message:

Executing the query "BACKUP DATABASE [MyCustDB] TO  DISK = N'\\\\JoeServer..." failed with the following error: "The operating system returned the error '21(failed to retrieve text for this error. Reason: 15105)' while attempting 'FsFileHeader::Read' on 'G:\\MyCustDB_2.MyCust_FileStream'.
The header for file 'G:\\MyCustDB_2.MyCust_FileStream' is not a valid database file header. The File Header property is incorrect.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


The database in running in SQL SERVER 2008R2.

Please help me on this.

Thanks

Joe
0
Comment
Question by:JOLEEJJ
  • 2
3 Comments
 
LVL 10

Expert Comment

by:PadawanDBA
ID: 39716944
Can you check the OS event logs for the corresponding error information so we can get more details?  My guess is there's an OS error preventing you from reading the file header, but we need to find that first.
0
 

Accepted Solution

by:
JOLEEJJ earned 0 total points
ID: 39725729
Hi

A simple server reboot has resolved the issue.

Thanks

Joe
0
 

Author Closing Comment

by:JOLEEJJ
ID: 39734478
Hi

A simple server reboot has resolved the issue.

Thanks

Joe
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
A procedure for exporting installed hotfix details of remote computers using powershell
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now