Share via

Backup failed for Server

  • Article
  • 08/20/2009

Question

Thursday, August 20, 2009 11:20 AM | 1 vote

I cannot backup my SQL database, following are the information I obtained from the Microsoft SQL (2005 Standard Edition) Server Management Studio after the backup was failed.

>Backup failed for Server 'SRV-A300'.  (Microsoft.SqlServer.Smo)

Set property Devices to accomplish this action. (Microsoft.SqlServer.Smo)<

-I set backup destination to local disk.

-I would like to start a fresh full backup. Thanks

All replies (5)

Thursday, August 20, 2009 1:02 PM ✅Answered | 5 votes

Hello,

Please, make sure you specify a file name when backing up to disk. There's no default file name for backups.

Regards,

Alberto Morillo
SQLCoffee.com

Thursday, August 20, 2009 12:19 PM | 1 vote

Hello,

Please, verify the service account for the MSSQLSERVER service have permissions over the physical file or folder on the hard drive that corresponds to the logical backup device that is being used to make the database backup.  If you are using a job to do the backup, please verify the permissions for the SQL SERVER AGENT service also.

Regards,

Alberto Morillo
SQLCoffee.com

Thursday, August 20, 2009 12:38 PM

Hello,

Please, read the following thread also:

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/c5e0d120-70a0-4165-8070-f483f12cbbce/

Regards,

Alberto Morillo
SQLCoffee.com

Monday, May 27, 2013 5:32 AM

Hello,

Same error her since this morning.

Eveything was working before: now I get this error message and have to specify a destination folder like the default one I was previously using is no more usable.

I don't understand why it occured: worked before/now have to process an other way.

Those kind of problems often occurs without making any changes and I'm getting bored of it.

What is the "technical" issue?

Wednesday, October 11, 2017 7:44 PM

I'm not sure how the SQL Server Agent user lost access to the backup folder, but all I had to do was look at Services to find the SQL Server Agent user and add permissions. Simple. Thanks @Alberto!