Ошибка операционной системы 5 отказано в доступе bak

#11199157

#11199154

#11199158

Я имел эту проблему недавно, однако я был запуск задания резервного копирования с сервера, но база данных резервного копирования на сервере в общей папке на сервере С. Когда агент на сервер говорит сервер B, чтобы выполнить резервное копирование, Т-SQL команды, его на самом деле обслуживание счета, что SQL выполняется на сервере B, который пытается записать резервную копию на сервере С.

Просто помните, что его учетная запись службы SQL-сервера, выполнив команду резервное копирование базы данных-это то, что должен иметь права на файловой системе, а не агент.

#11199162

Я был просто переживает это сам. Я заверил, что мой логин был именно mssqlserver полный доступ, но это было все еще вызывает вопросы. Он только один раз работал я переехала назначения в корень С. Еще более важно из папки пользователя (хотя у меня была поделиться со всеми разрешениями — даже пытался, что «Все» в качестве теста).

Я не’т знать, если я считаю, что мой вопрос на «фиксированный» и, однако, он является»рабочее&quot&;.

Просто к сведению для других пользователей, которые приходят через этот поток.

#11199164

Я сталкиваюсь с той же проблемой с SQL Экспресс 2014 SP1 на Windows 10.

Решение, которое работает

1. Откройте службу, введя услуг
2. Найдите и откройте SQL сервер (отчеты)
3. Перейдите на вкладку Вход в систему
4. Выберите локальную системную учетную запись ( также проверить услуг для разрешить взаимодействие с рабочим столом )
5. Нажмите кнопку ОК . Остановить службу . Перезапустите службу.
6. Проблема решена

#11199170

Для того, чтобы узнать, какой пользователь вы должны дать разрешение, чтобы сделать процесс восстановления, вы можете выполнить следующие действия:

Вам нужно идти к вашему сервере, где установлен SQL-сервер. Найти диспетчер конфигурации SQL-сервера

Далее, вам нужно идти, чтобы «SQL сервер служб и»

Под SQL-сервер (служба mssqlserver) экземпляр появится аккаунт с колонкой на «входа», в моем случае это служба NTимя mssqlserver.

Это счет, который нужно добавить на вкладке Безопасность вашего источника .бак местоположения и дать этому пользователю в «Читать» и разрешения, так что файл резервной копии можно прочитать.

Позвольте’ы сказать ваш файл резервного копирования в «D:Shared» папка, то нужно дать подобного разрешения:

#11199155

#11199165

Вот что я сделал, чтобы обойти эту проблему.

1. Заходим в резервное копирование

2. удалить файл-путь на диск

3. Нажмите на кнопку Добавить

4. в имени файла: флажок вручную ввести имя резервной копии, после резервной копии ..как ниже, где Yourdb.BAK-имя резервной копии базы данных

C:Program файлыMSSQL11 Майкрософт SQL сервер.Имя mssqlserverMSSQL данныхрезервное копированиеYourdb.бак

1. Нажмите кнопку ОК

Надеюсь, что это помогает!

#11199163

#11199161

Пожалуйста, проверьте доступ к дискам.Сначала создайте одну папку и заходим в Свойства папки ,

Вы можете найти вкладку Безопасность ,нажмите на эту проверить, есть ли ваш ID пользователя, имеющего доступ или нет.

если бы’т найти ваш ID,пожалуйста, нажмите на Добавить кнопок и дать имя пользователя с полным доступом.

#11199166

Общий доступ к этой папке и использовать UNC-путь, например: ПКрезервное копированиебазы данных mydb.бак

Тогда вы можете прекратить акцию.

Не очень элегантный, но он решает все проблемы с разрешениями (вы должны дать разрешения на акцию, а также, Как упоминалось выше)

#11199167

Я сталкивалась с этой проблемой, когда .Файл BAK был временно хранятся в папке зашифрованном с помощью BitLocker. Он сохранил шифрования после того, как он был перемещен в другую папку.

Учетная запись сетевой службы не удалось расшифровать файл и дал тщательно информативное сообщение об ошибке.

Снятие шифрования BitLocker (исключая «и шифровать содержимое для защиты данных» в свойствах файла) на .Файл BAK решен вопрос.

#11199168

Привет вам нужно изменить запрос:

для

Вы должны добавить N в перед путь работает для меня.

#11199169

У меня такая же ошибка. Следующие изменения помогли мне это исправить.

Я должен был проверить диспетчер сервера-и gt;Инструменты->Услуги и найти пользователя (на»Журнал
О как» столбик) для обслуживания следующих объектов: SQL-сервер (отчеты).

Я пошел в локальную папку (C:UsersMeDesktopBackup) и добавил, что «НТ
отчеты&яслужба MSSQL$; как пользователю дать права на запись.

#11199160

Сообщение 3201, Уровень 16, Состояние 1, Строка 1
Невозможно открыть устройство резервного копирования ‘C:BackupAdventure_20120720_1024AM.trn’. Ошибка операционной системы 5(отказано в доступе).
Сообщение 3013, Уровень 16, Состояние 1, Строка 1
Журнал резервного копирования завершается аварийно.

Я проверил папку резервного копирования на диск C, это новая учетная запись службы имеет полный доступ разрешение на доступ или нет?, Я понял, что «Тест Киран» и учетная запись службы не имея полного доступа безопасности.

Пожалуйста, следуйте ниже шагов, чтобы дать полный контроль для учетной записи службы:

1. Перейти на диск C, щелкните правой кнопкой мыши на папке Backup.
2. Выберите вкладку Безопасность.
3. Нажмите на кнопку Редактировать, откроется новое окно.
4. Нажмите на кнопку Добавить и введите тестовую учетную запись пользователяКиран и нажмите кнопку Проверить имя, это будет проверять введенные пользователем или нет, если он существует, он будет показывать пользователю окно, выберите ОК.
5. Выберите вы ввели имя пользователя и выберите полный доступ установите флажок Разрешить.

#11199171

Одна из причин, почему это происходит, вы бежите ваша служба mssqlserver не используя локальную систему. Чтобы устранить эту проблему, выполните следующие действия.

1. Откройте окно Выполнить с помощью Windows + Р
2. Тип услуг.МСЦ и диалоговое окно Services откроет
3. Найти SQL сервер (служба mssqlserver)
4. Щелкните правой кнопкой мыши и выберите пункт «Свойства».
5. Перейдите в журнал на вкладке
6. Выберите локальную системную учетную запись и нажмите на «применить» и «ОК»и
7. Нажмите на ссылку остановить на панели слева, выбрав «и SQL-сервер (служба mssqlserver)» и запустить его снова, как только полностью остановлен.
8. Наслаждайтесь вашей резервной копии.

Надеемся это поможет вам хорошо, как это сделали со мной. Ура!

#11199172

SQL сервер не может получить доступ (писать) резервное копирование в указанное место.

Сначала нужно проверить учетную запись службы, на котором SQL-сервер работает. Это можно сделать с помощью Configuration Manager или услуг.МСЦ.

или

Использовать ниже запроса :

выберите ДСС.имя_службы,
ДСС.startup_type_desc,
ДСС.status_desc,
ДСС.last_startup_time,
ДСС.service_account,
ДСС.is_clustered,
ДСС.cluster_nodename,
ДСС.именем,
ДСС.startup_type,
ДСС.статус
ДСС.идентификатор_процесса из sys.dm_server_services как ДСС;

Теперь посмотрим на service_account столбца и запишите это.

Перейдите к расположению, где вы пытаетесь взять резервную копию.В вашем случае : C:UsersMeDesktopBackup

Щелкните правой кнопкой мыши—> Свойства —> безопасность-и GT;

Добавьте учетную запись службы и обеспечивают чтение/запись. Это позволит решить проблему.

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