I tried to back up a server I created in SQL Server, but I received the following message:

TITLE: Microsoft SQL Server Management Studio

Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)

For help, click: ((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

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

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

For help, click: ((KJ_PCU_Main).120628-0827+)&LinkId=20476

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

OK

I failed to understand how to resolve this problem, and the added links were not of much help, either. I'll be extremely glad if someone could explain this to me :)

0

1 Answer

You don't have permission to access C:\Users\Flight.bak. Specifically, the problem is probably with accessing C:\Users\, where you need administrator permissions, so a non-administrator account cannot write directly to that folder.

You should choose another folder, perhaps C:\Users\YOUR-NAME to which you have full permissions. You could also create a folder named C:\Users\YOUR-NAME\Backupsor similar, or maybe create another folder on C:\ to hold the backups.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy