Solved

SQL 2012 Backup Fails

Posted on 2013-05-23
1
1,283 Views
Last Modified: 2013-09-11
I have two SQL 2012 instances participating in an AlwaysOn AG.  Several databases belong to this AG.  My maintenance plan is set up to backup the databases each under its own folder.  The maintenance plan fails, however.

In the maintenance plan report, the error is:
Failed:(-1073548784) Executing the query "declare @backupSetId as int
select @backupSetId =..." failed with the following error: "Cannot open backup device 'F:\\SQLBackups\\Database10\\Database10_backup_2013_05_23_145749_1490355.bak'. Operating system error 2(The system cannot find the file specified.).
VERIFY 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.

I know how this error is commonly due to file permissions so in troubleshooting I have set the path to the backup folder to be an empty folder with EVERYONE = FULL permissions.  Subfolders are created for each of the databases, however the .bak files are not created and the process fails.
0
Comment
Question by:LNKDLNY2
1 Comment
 

Accepted Solution

by:
LNKDLNY2 earned 0 total points
ID: 39195334
Go figure... I was able to resolve.  The db was a member of an availability group and it was not configured for backups on Primary.  The secondary server had bad permissions on the destination backup path.  Both scenarios gave identical error.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

792 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