Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CharlierTU
Starting Member
1 Post |
 Posted - 2015-03-16 : 19:42:07
|
| I tried to use SSMS 2014 maintenance plans to backup databases I am testing in an Availability group. I am failing badly.I have the Availability Groups set to "Prefer Secondary" on both the primary and the secondary. I created the same Full Backup Maintenance plan on both the Primary and Replica nodes. I tried executing the maintenance plans from both nodes.... they fail on both. I looked in the Server Log and see this message:From Primary========BackupDiskFile::OpenMedia: Backup device 'J:\Backup\forms\forms_backup_2015_03_16_154013_0667087.bak' failed to open. Operating system error 2(The system cannot find the file specified.).From Secondary==========BACKUP failed to complete the command BACKUP DATABASE forms. Check the backup application log for detailed messages.The Oracle guys feel you need to write a script and it cannot ne performed from SSMS.... has anyone completed this process. If so, please let me know what I am missing.Thanks!CraigCR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-16 : 19:44:10
|
| The error has nothing to do with the AG setup. Does the J drive exist from the SQL Server service's perspective? Does the account have full access to the folder?Yes you can complete this through SSMS. Tip: Oracle guys know Oracle.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
New to AAG and cannot get backups to work