MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: Backup failed for Server ''. (Microsoft.SqlServer.SmoExtended)  (Read 14421 times)

0 Members and 1 Guest are viewing this topic.

Offline Administrator

  • Chinmay Dingore
  • Administrator
  • Full Member
  • *****
  • Posts: 135
  • Karma: +1/-0
    • View Profile
    • MilesWeb Internet Services Pvt Ltd
Backup failed for Server ''. (Microsoft.SqlServer.SmoExtended)
« on: January 18, 2016, 06:45:54 PM »
When initiating a backup of MSSQL database using SQL Management Studio, you might get the error as below.

Quote
TITLE: Microsoft SQL Server Management Studio
------------------------------

Backup failed for Server ''.  (Microsoft.SqlServer.SmoExtended)

For help, click: go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.5058.0+((SQL11_PCU_Main).140514-1820+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Cannot open backup device 'C:\backup.bak'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)

For help, click: go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.5058.0+((SQL11_PCU_Main).140514-1820+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

This error is due to incorrect permissions on the folder under which the backup file is generated. Simply, add network user's permission on that folder & you will be able to generate the backups.
MilesWeb.com - Your Hosting, Our Responsibility!
Unlimited Hosting Plans | Managed VPS with 20% Discount

MilesWeb Hosting Forum

Backup failed for Server ''. (Microsoft.SqlServer.SmoExtended)
« on: January 18, 2016, 06:45:54 PM »