Not able to bowse backup file while restoring a database in sql server 2005 . . . . . .

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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

SQL

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

SQL

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.

Posted 29-Oct-14 18:58pm

Thrilok SQL DBA

Add a Solution

Comments

srilekhamenon 30-Oct-14 1:24am

iam not sure, but iam feeling there is a issue with the user rights, What operating system you are working with ?

Thrilok SQL DBA 30-Oct-14 5:34am

Hi Menon you are bit of correct, that is only sysadmin only can view the windows path . . . . Except sysadmin right nobody can access the windows path.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thrilok SQL DBA · Accepted Answer · 2014-10-29T23:36:00

Solution 1

Only sysadmin only can view the windows path . . . . Except sysadmin right nobody can access the windows path.

Regard's,
Thrilok.

Posted 29-Oct-14 23:36pm

Thrilok SQL DBA