Невозможно открыть устройство резервного копирования ошибка операционной системы 5

#11199156

Да, я только что забил его.

Загляните в Службы Windows. Пуск > Администрирование > Службы

Найдите в списке службу под названием: SQL Server (MSSQLSERVER) найдите колонку «Log On As» (нужно добавить ее, если ее нет в списке).

Это учетная запись, которой нужно дать разрешения на каталог, щелкните правой кнопкой мыши в проводнике > свойства > Общие ресурсы (и безопасность).

ПРИМЕЧАНИЕ: Не забудьте дать права на фактический каталог и на общий ресурс, если вы работаете по сети.

Примените и подождите, пока разрешения не будут установлены, и повторите попытку резервного копирования.

ПРИМЕЧАНИЕ 2: если вы выполняете резервное копирование по сети, а ваш SQL работает как «Локальная служба», то у вас проблемы… Вы можете попробовать назначить разрешения или проще сделать резервную копию локально и скопировать ее за пределы SQL Server (через час).

ПРИМЕЧАНИЕ 3: Если вы работаете как сетевая служба, то в некоторых случаях удаленная машина не распознает сетевую службу на вашем SQL Server. В этом случае вам нужно добавить разрешения для самого компьютера, например, MyServer$.

Ответ на вопрос

21-го марта 2012 в 5:34

2012-03-21T17:34:13+00:00

Ответ на вопрос

18-го октября 2010 в 3:04

2010-10-18T15:04:06+00:00

Ответ на вопрос

3-го октября 2012 в 2:47

2012-10-03T02:47:26+00:00

Ответ на вопрос

2-го апреля 2014 в 6:13

2014-04-02T18:13:23+00:00

Ответ на вопрос

26-го июля 2016 в 7:33

2016-07-26T19:33:00+00:00

Ответ на вопрос

6-го октября 2018 в 4:48

2018-10-06T04:48:28+00:00

Ответ на вопрос

19-го апреля 2011 в 2:31

2011-04-19T14:31:25+00:00

Ответ на вопрос

29-го августа 2016 в 6:45

2016-08-29T06:45:10+00:00

Ответ на вопрос

7-го июля 2016 в 11:42

2016-07-07T11:42:44+00:00

Ответ на вопрос

21-го августа 2013 в 12:23

2013-08-21T12:23:44+00:00

Ответ на вопрос

24-го сентября 2016 в 9:16

2016-09-24T09:16:14+00:00

Ответ на вопрос

25-го октября 2016 в 8:05

2016-10-25T20:05:48+00:00

Ответ на вопрос

8-го мая 2017 в 2:42

2017-05-08T02:42:46+00:00

Ответ на вопрос

12-го декабря 2017 в 1:32

2017-12-12T13:32:48+00:00

Ответ на вопрос

6-го июня 2013 в 9:35

2013-06-06T09:35:30+00:00

Ответ на вопрос

3-го июля 2019 в 6:43

2019-07-03T06:43:24+00:00

Ответ на вопрос

28-го августа 2019 в 1:13

2019-08-28T13:13:16+00:00

Below is the query that I am using to backup (create a .bak) my database.

However, whenever I run it, I always get this error message:

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:UsersMeDesktopBackupMyDB.Bak’. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This is my query:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersMeDesktopBackupMyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

Go to the SQL server folder in start menu and click configuration tools
Select SQL Server configuration manager
On SQL server services, on the desired instance change the (Log On as) to local system

The SQL Server service account does not have permissions to write to the folder C:UsersKimpoyDesktopBackup

I had this issue recently as well, however I was running the backup job from server A but the database being backed up was on server B to a file share on server C. When the agent on server A tells server B to run a backup t-sql command, its actually the service account that sql is running under on SERVER B that attempts to write the backup to server C.

Just remember, its the service account of the sql server performing the actual BACKUP DATABASE command is what needs privileges on the file system, not the agent.

answered Oct 3, 2012 at 2:47

I face the same problem with SQL Express 2014 SP1 on Windows 10.

Solution which work

1. Open Service by typing Services
2. Locate and open the SQL Server (SQLExpress)
3. Go to the LogOn Tab
4. Choose Local System Account ( Also Check for Allow Services to interact with desktop )
5. Click OK . Stop the service . Restart the service.
6. Problem solved

answered Jul 26, 2016 at 19:33

I had a similar issue. I added write permissions to the .bak file itself, and my folder that I was writing the backup to for the NETWORK SERVICE user. To add permissions just right-click what file/directory you want to alter, select the security tab, and add the appropriate users/permissions there.

Here is what I did to by-pass the issue.

1) Go to backup

2) Remove the destination file-path to disk

3) Click on Add

4) In the File name: check box manually type in the backup name after ..backup like below where Yourdb.bak is the database backup name

C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLBackupYourdb.bak

5) Click on OK

Hope this helps!

I solved the same problem with the following 3 steps:

1. I store my backup file in other folder path that’s worked right.
2. View different of security tab two folders (as below image).
3. Edit permission in security tab folder that’s not worked right.

answered Jul 24, 2020 at 13:06

I know it is not an exact solution but using external drive paths solves this problem.

BACKUP DATABASE AcinsoftDB
TO DISK = 'E:MyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

answered Jul 7, 2016 at 11:42

I have the same error. Following changes helped me to fix this.

I had to check Server Manager->Tool->Services and find the user («Log
On As» column) for service: SQL Server (SQLEXPRESS).

I went to the local folder (C:UsersMeDesktopBackup) and added «NT
ServiceMSSQL$SQLEXPRESS» as the user to give Write permissions.

answered Dec 12, 2017 at 13:32

SQL Server is not able to access (write) the backup into the location specified.

First you need to verify the service account on which the Sql server is running. This can be done by using Configuration manager or Services.msc.

or

Use below query :

SELECT  DSS.servicename,
    DSS.startup_type_desc,
    DSS.status_desc,
    DSS.last_startup_time,
    DSS.service_account,
    DSS.is_clustered,
    DSS.cluster_nodename,
    DSS.filename,
    DSS.startup_type,
    DSS.status,
    DSS.process_id FROM    sys.dm_server_services AS DSS;

Now look at the column service_account and note it down.

Go to the location where you are trying to take the backup.In your case : C:UsersMeDesktopBackup

Right click—> Properties —> Security —>

Add the service account and provide read/write permissions. This will resolve the issue.

answered Aug 28, 2019 at 13:13

In my case, I forgot to name the backup file and it kept giving me the same permission error :/

TO DISK N'{path}WRITE_YOUR_BACKUP_FILENAME_HERE.bak'

answered Feb 3, 2020 at 10:58

answered Mar 28, 2013 at 12:09

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:BackupAdventure_20120720_1024AM.trn’. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

I verified backup folder on C drive, Is new service account is having full control access permission or not?, I realized that «TestKiran» service account is not having Full control security permission.

Please follow the below steps to give full control to service account:

1. Go to C drive, Right click on Backup folder.
2. Select Security tab.
3. Click on Edit button, new window will open.
4. Click on Add button and enter TestKiran user account and click check name button, this will validate you entered user is existing or not, if it is existing it will show the user on window, select OK.
5. Select you entered user name and select Full Control check box under allow.

Please check the access to drives.First create one folder and go to folder properties ,

You may find the security tab ,click on that check whether your user id having the access or not.

if couldn’t find the your id,please click the add buttion and give user name with full access.

answered Aug 21, 2013 at 12:23

Share this folder and use UNC path, by example: pcbackupsmydb.bak

Then You can stop share.

Not very elegant, but it resolves all permissions problems (You need to give permissions to share as well, as mentioned above)

answered Sep 24, 2016 at 9:16

I experienced this problem when the .BAK file was temporarily stored in a folder encrypted with BitLocker. It retained the encryption after it was moved to a different folder.

The NETWORK SERVICE account was unable to decrypt the file and gave this thoroughly informative error message.

Removing BitLocker encryption (by unchecking «Encrypt contents to secure data» in the file properties) on the .BAK file resolved the issue.

answered Oct 25, 2016 at 20:05

Hi you need to change the query from:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersMeDesktopBackupMyDB.Bak'

to

BACKUP DATABASE AcinsoftDB
TO DISK = N'C:UsersMeDesktopBackupMyDB.Bak'

You have to add a N in front of the path works for me.

answered Jan 26, 2021 at 17:46

answered Mar 23, 2022 at 8:28

Make sure you are actually saving to a FILE and not a folder,

My problem was I was simply putting in the Folder path and not the File path

You want this

'F:Database BackupPharmacydata.bak';

You dont want this

'F:Database BackupPharmacy';

answered Oct 27, 2022 at 17:23

Below is the query that I am using to backup (create a .bak) my database.

However, whenever I run it, I always get this error message:

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:UsersMeDesktopBackupMyDB.Bak’. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This is my query:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersMeDesktopBackupMyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

Go to the SQL server folder in start menu and click configuration tools
Select SQL Server configuration manager
On SQL server services, on the desired instance change the (Log On as) to local system

The SQL Server service account does not have permissions to write to the folder C:UsersKimpoyDesktopBackup

I had this issue recently as well, however I was running the backup job from server A but the database being backed up was on server B to a file share on server C. When the agent on server A tells server B to run a backup t-sql command, its actually the service account that sql is running under on SERVER B that attempts to write the backup to server C.

Just remember, its the service account of the sql server performing the actual BACKUP DATABASE command is what needs privileges on the file system, not the agent.

answered Oct 3, 2012 at 2:47

I face the same problem with SQL Express 2014 SP1 on Windows 10.

Solution which work

1. Open Service by typing Services
2. Locate and open the SQL Server (SQLExpress)
3. Go to the LogOn Tab
4. Choose Local System Account ( Also Check for Allow Services to interact with desktop )
5. Click OK . Stop the service . Restart the service.
6. Problem solved

answered Jul 26, 2016 at 19:33

I had a similar issue. I added write permissions to the .bak file itself, and my folder that I was writing the backup to for the NETWORK SERVICE user. To add permissions just right-click what file/directory you want to alter, select the security tab, and add the appropriate users/permissions there.

Here is what I did to by-pass the issue.

1) Go to backup

2) Remove the destination file-path to disk

3) Click on Add

4) In the File name: check box manually type in the backup name after ..backup like below where Yourdb.bak is the database backup name

C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLBackupYourdb.bak

5) Click on OK

Hope this helps!

I solved the same problem with the following 3 steps:

1. I store my backup file in other folder path that’s worked right.
2. View different of security tab two folders (as below image).
3. Edit permission in security tab folder that’s not worked right.

answered Jul 24, 2020 at 13:06

I know it is not an exact solution but using external drive paths solves this problem.

BACKUP DATABASE AcinsoftDB
TO DISK = 'E:MyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

answered Jul 7, 2016 at 11:42

I have the same error. Following changes helped me to fix this.

I had to check Server Manager->Tool->Services and find the user («Log
On As» column) for service: SQL Server (SQLEXPRESS).

I went to the local folder (C:UsersMeDesktopBackup) and added «NT
ServiceMSSQL$SQLEXPRESS» as the user to give Write permissions.

answered Dec 12, 2017 at 13:32

SQL Server is not able to access (write) the backup into the location specified.

First you need to verify the service account on which the Sql server is running. This can be done by using Configuration manager or Services.msc.

or

Use below query :

SELECT  DSS.servicename,
    DSS.startup_type_desc,
    DSS.status_desc,
    DSS.last_startup_time,
    DSS.service_account,
    DSS.is_clustered,
    DSS.cluster_nodename,
    DSS.filename,
    DSS.startup_type,
    DSS.status,
    DSS.process_id FROM    sys.dm_server_services AS DSS;

Now look at the column service_account and note it down.

Go to the location where you are trying to take the backup.In your case : C:UsersMeDesktopBackup

Right click—> Properties —> Security —>

Add the service account and provide read/write permissions. This will resolve the issue.

answered Aug 28, 2019 at 13:13

In my case, I forgot to name the backup file and it kept giving me the same permission error :/

TO DISK N'{path}WRITE_YOUR_BACKUP_FILENAME_HERE.bak'

answered Feb 3, 2020 at 10:58

answered Mar 28, 2013 at 12:09

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:BackupAdventure_20120720_1024AM.trn’. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

I verified backup folder on C drive, Is new service account is having full control access permission or not?, I realized that «TestKiran» service account is not having Full control security permission.

Please follow the below steps to give full control to service account:

1. Go to C drive, Right click on Backup folder.
2. Select Security tab.
3. Click on Edit button, new window will open.
4. Click on Add button and enter TestKiran user account and click check name button, this will validate you entered user is existing or not, if it is existing it will show the user on window, select OK.
5. Select you entered user name and select Full Control check box under allow.

Please check the access to drives.First create one folder and go to folder properties ,

You may find the security tab ,click on that check whether your user id having the access or not.

if couldn’t find the your id,please click the add buttion and give user name with full access.

answered Aug 21, 2013 at 12:23

Share this folder and use UNC path, by example: pcbackupsmydb.bak

Then You can stop share.

Not very elegant, but it resolves all permissions problems (You need to give permissions to share as well, as mentioned above)

answered Sep 24, 2016 at 9:16

I experienced this problem when the .BAK file was temporarily stored in a folder encrypted with BitLocker. It retained the encryption after it was moved to a different folder.

The NETWORK SERVICE account was unable to decrypt the file and gave this thoroughly informative error message.

Removing BitLocker encryption (by unchecking «Encrypt contents to secure data» in the file properties) on the .BAK file resolved the issue.

answered Oct 25, 2016 at 20:05

Hi you need to change the query from:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersMeDesktopBackupMyDB.Bak'

to

BACKUP DATABASE AcinsoftDB
TO DISK = N'C:UsersMeDesktopBackupMyDB.Bak'

You have to add a N in front of the path works for me.

answered Jan 26, 2021 at 17:46

answered Mar 23, 2022 at 8:28

Make sure you are actually saving to a FILE and not a folder,

My problem was I was simply putting in the Folder path and not the File path

You want this

'F:Database BackupPharmacydata.bak';

You dont want this

'F:Database BackupPharmacy';

answered Oct 27, 2022 at 17:23

Below is the query that I am using to backup (create a .bak) my database.

However, whenever I run it, I always get this error message:

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:UsersMeDesktopBackupMyDB.Bak’. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This is my query:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersMeDesktopBackupMyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

Go to the SQL server folder in start menu and click configuration tools
Select SQL Server configuration manager
On SQL server services, on the desired instance change the (Log On as) to local system

The SQL Server service account does not have permissions to write to the folder C:UsersKimpoyDesktopBackup

I had this issue recently as well, however I was running the backup job from server A but the database being backed up was on server B to a file share on server C. When the agent on server A tells server B to run a backup t-sql command, its actually the service account that sql is running under on SERVER B that attempts to write the backup to server C.

Just remember, its the service account of the sql server performing the actual BACKUP DATABASE command is what needs privileges on the file system, not the agent.

answered Oct 3, 2012 at 2:47

I face the same problem with SQL Express 2014 SP1 on Windows 10.

Solution which work

1. Open Service by typing Services
2. Locate and open the SQL Server (SQLExpress)
3. Go to the LogOn Tab
4. Choose Local System Account ( Also Check for Allow Services to interact with desktop )
5. Click OK . Stop the service . Restart the service.
6. Problem solved

answered Jul 26, 2016 at 19:33

I had a similar issue. I added write permissions to the .bak file itself, and my folder that I was writing the backup to for the NETWORK SERVICE user. To add permissions just right-click what file/directory you want to alter, select the security tab, and add the appropriate users/permissions there.

Here is what I did to by-pass the issue.

1) Go to backup

2) Remove the destination file-path to disk

3) Click on Add

4) In the File name: check box manually type in the backup name after ..backup like below where Yourdb.bak is the database backup name

C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLBackupYourdb.bak

5) Click on OK

Hope this helps!

I solved the same problem with the following 3 steps:

1. I store my backup file in other folder path that’s worked right.
2. View different of security tab two folders (as below image).
3. Edit permission in security tab folder that’s not worked right.

answered Jul 24, 2020 at 13:06

I know it is not an exact solution but using external drive paths solves this problem.

BACKUP DATABASE AcinsoftDB
TO DISK = 'E:MyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

answered Jul 7, 2016 at 11:42

I have the same error. Following changes helped me to fix this.

I had to check Server Manager->Tool->Services and find the user («Log
On As» column) for service: SQL Server (SQLEXPRESS).

I went to the local folder (C:UsersMeDesktopBackup) and added «NT
ServiceMSSQL$SQLEXPRESS» as the user to give Write permissions.

answered Dec 12, 2017 at 13:32

SQL Server is not able to access (write) the backup into the location specified.

First you need to verify the service account on which the Sql server is running. This can be done by using Configuration manager or Services.msc.

or

Use below query :

SELECT  DSS.servicename,
    DSS.startup_type_desc,
    DSS.status_desc,
    DSS.last_startup_time,
    DSS.service_account,
    DSS.is_clustered,
    DSS.cluster_nodename,
    DSS.filename,
    DSS.startup_type,
    DSS.status,
    DSS.process_id FROM    sys.dm_server_services AS DSS;

Now look at the column service_account and note it down.

Go to the location where you are trying to take the backup.In your case : C:UsersMeDesktopBackup

Right click—> Properties —> Security —>

Add the service account and provide read/write permissions. This will resolve the issue.

answered Aug 28, 2019 at 13:13

In my case, I forgot to name the backup file and it kept giving me the same permission error :/

TO DISK N'{path}WRITE_YOUR_BACKUP_FILENAME_HERE.bak'

answered Feb 3, 2020 at 10:58

answered Mar 28, 2013 at 12:09

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘C:BackupAdventure_20120720_1024AM.trn’. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

I verified backup folder on C drive, Is new service account is having full control access permission or not?, I realized that «TestKiran» service account is not having Full control security permission.

Please follow the below steps to give full control to service account:

1. Go to C drive, Right click on Backup folder.
2. Select Security tab.
3. Click on Edit button, new window will open.
4. Click on Add button and enter TestKiran user account and click check name button, this will validate you entered user is existing or not, if it is existing it will show the user on window, select OK.
5. Select you entered user name and select Full Control check box under allow.

Please check the access to drives.First create one folder and go to folder properties ,

You may find the security tab ,click on that check whether your user id having the access or not.

if couldn’t find the your id,please click the add buttion and give user name with full access.

answered Aug 21, 2013 at 12:23

Share this folder and use UNC path, by example: pcbackupsmydb.bak

Then You can stop share.

Not very elegant, but it resolves all permissions problems (You need to give permissions to share as well, as mentioned above)

answered Sep 24, 2016 at 9:16

I experienced this problem when the .BAK file was temporarily stored in a folder encrypted with BitLocker. It retained the encryption after it was moved to a different folder.

The NETWORK SERVICE account was unable to decrypt the file and gave this thoroughly informative error message.

Removing BitLocker encryption (by unchecking «Encrypt contents to secure data» in the file properties) on the .BAK file resolved the issue.

answered Oct 25, 2016 at 20:05

Hi you need to change the query from:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersMeDesktopBackupMyDB.Bak'

to

BACKUP DATABASE AcinsoftDB
TO DISK = N'C:UsersMeDesktopBackupMyDB.Bak'

You have to add a N in front of the path works for me.

answered Jan 26, 2021 at 17:46

answered Mar 23, 2022 at 8:28

Make sure you are actually saving to a FILE and not a folder,

My problem was I was simply putting in the Folder path and not the File path

You want this

'F:Database BackupPharmacydata.bak';

You dont want this

'F:Database BackupPharmacy';

answered Oct 27, 2022 at 17:23