Hi,
Recently i got a requirement to create a login for only backup and restore for specified databases, so i have created a login like that. But here i am facing an issue i.e. while taking backup i not able to browse the backup location and not able to browse backup file while restoring a database.
Through command backup and restore is working fine.
I am getting this error while browsing for backup location
TITLE: Locate Database Files - TESTSVR\GTUNEW
C:\Program Files\Microsoft SQL Server\MSSQL.56\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
BUTTONS:
OK
Error for restoring a database
TITLE: Locate Backup File - TESTSVR\GTUNEW
C:\Program Files\Microsoft SQL Server\MSSQL.56\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
BUTTONS:
OK
please suggest me regarding this, i have tried all possible answers from google and other sites but i couldn't.
Regard'd,
Thrilok.