0

I'm trying to perform a database restore but display the message as follows. enter image description here Can anyone help me with this problem? Thank you very much.

On SQL Server Management Studio 2017

  • Right click Databases on left pane (Object Explorer)
  • Click Restore Database...
  • Choose Device, click ... to display Select Backup Devices box, then click the Add button to select add .bak file But display the message as follows. enter image description here
Văn Vân
  • 3
  • 3
  • Your user has insufficient permissions. The specific permission needed that relates to the actual error message you are seeing is "VIEW SERVER STATE" (some details about that system proc here https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/relational-databases/system-dynamic-management-views/sys-dm-os-enumerate-fixed-drives.md). However, I suspect that ultimately you are just accessing SQL Server with a user that does not have sufficient server role granted to restore a database – Craig Feb 14 '23 at 03:41

0 Answers0