Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sqlback up failure

Posted on 2013-12-12
3
Medium Priority
?
276 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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

963 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