sqlback up failure
Posted on 2013-12-12
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).
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.