Share via

Backup failed for Server 2008R2/ SQL Server 2008 R2

  • Article

Question

Thursday, June 9, 2011 1:18 AM

TITLE: Microsoft SQL Server Management Studio

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Cannot open backup device 'F:\BK30052011_1730.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105). (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476

BUTTONS:

OK

I'm install and backup complete 1 time but I go to update all services windows server 2008 R2

After that I can not backup Database

Thank you

All replies (3)

Thursday, June 9, 2011 1:20 AM âś…Answered

Verify that Sql Server (account under it runs) has permissions to the F:\ drive and to that file if the file existsWith kind regards
Krystian Zieja
http://www.projectnenvision.com
Follow me on twitter
My Blog

Thursday, June 9, 2011 2:50 AM

Verify that Sql Server (account under it runs) has permissions to the F:\ drive and to that file if the file exists With kind regards
Krystian Zieja
http://www.projectnenvision.com
Follow me on twitter
My Blog

Thank you 

After create new folder on driver f:\BK_Base and add permission I can backup database

Wednesday, September 18, 2013 2:57 PM

sure is allowed access to the folder that is performing the backup, I changed the permissions and it worked.