Highlighted
Micro Focus Contributor
Micro Focus Contributor
79 views

Unable to run the DMA flow (MS SQL Database Backup and Restore).

Hi Team,

We are trying to take backup from a (source database) different server and restoring the backup to the (target database) another server. But we are getting below error Operating system error 5(Access is denied). When we checked the prerequisites in docs.microfocus we found that read and write permission is required, we have given the same but still we are getting the same error.  

Flow inputs: source, target, working path is on a network share, windows share password and user.

 

Please find the step error below

Gather Parameters for MS SQL Database Backup and Restore

30 Jun 20:02 - 30 Jun 20:03Exit: 0Server: mc4w01888.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Gather Advanced Parameters for MS SQL Database Backup and Restore

30 Jun 20:03 - 30 Jun 20:03Exit: 0Server: mc4w01888.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Run MS SQL Pre-Backup Validation

30 Jun 20:03 - 30 Jun 20:05Exit: 0Server: mc4w01950.microfocus.com, Instance: MSSQLSERVER, Database: msdb

  [WARNING]: Unable to check free space on shared drive because Windows Share User and Password not provided

Backup MS SQL Database

30 Jun 20:05 - 30 Jun 20:05Exit: 0Server: mc4w01950.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Run MS SQL Post-Backup Validation

30 Jun 20:05 - 30 Jun 20:06Exit: 0Server: mc4w01950.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Run MS SQL Pre-Restore Validation

30 Jun 20:06 - 30 Jun 20:07Exit: 1Server: mc4w01888.microfocus.com, Instance: MSSQLSERVER, Database: msdb

  [ERROR]:

  [.....]: Traceback (most recent call last):

  [.....]:   File "c:\users\mssql\appdata\local\temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\stepcode.py", line 583, in <module>

  [.....]:     main()

  [.....]:   File "c:\users\mssql\appdata\local\temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\stepcode.py", line 503, in main

  [.....]:     backup_file_dict = sqlservertools.query_backup_file(data_file, instance_user=RUNAS_USERNAME, instance_password=RUNAS_PASSWORD)

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\sqlservertools.py", line 514, in query_backup_file

  [.....]:     result_set = sql_conn.query_with_headers(sql,

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\sqlservertools.py", line 263, in query_with_headers

  [.....]:     raw_result = self.query(sql, result_type=result_type)

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\databaseconnection.py", line 57, in query

  [.....]:     return cur.fetchall(parse=parse, result_type=result_type,

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\databaseconnection.py", line 43, in fetchall

  [.....]:     return self._query(parse=parse, result_type=result_type,

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\sqlservertools.py", line 172, in _query

  [.....]:     raise self.DatabaseError(msg % (status, output, errors))

  [.....]: DatabaseError: Query failed with return code "1" -- "Msg 3201, Level 16, State 2, Server MC4W01888, Line 2\r\nCannot open backup device '\\\\MC4W01950\\Temp\\msdb_20200630_143504.bak'. Operating system error 5(Access is denied.).\r\nMsg 3013, Level 16, State 1, Server MC4W01888, Line 2\r\nRESTORE HEADERONLY is terminating abnormally.\r\n"; ''

  [ERROR]: Query failed with return code "1" -- "Msg 3201, Level 16, State 2, Server MC4W01888, Line 2\r\nCannot open backup device '\\\\MC4W01950\\Temp\\msdb_20200630_143504.bak'. Operating system error 5(Access is denied.).\r\nMsg 3013, Level 16, State 1, Server MC4W01888, Line 2\r\nRESTORE HEADERONLY is terminating abnormally.\r\n"; ''

 

 

Any suggestions on how we can resolve/ causes for the error would be helpful.

0 Likes
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.