INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL server 2008 R2 backup restore issue

SQL server 2008 R2 backup restore issue

(OP)
Hi I'm new to SQL 2008 R2. this is situation I face to: we have 2 servers run a application, for some reason database is on the 2003 server and application itself running on a 2008 R2 (64bit)server. SQL server 2008 R2 is running on both server.
now we're going to migrate DB to application server. I made a backup through management studio on DB server and then copy it to "C" on the application server and make sharing with sql service account in the domain. but when I try to restore it through sql management studio on application server I got the following error: The Database Engine service could not resolve the specified file location. Either the location does not exist, or the current login account does not have access to it. Verify that the file location exists, and that the login account has permissions on it. I have no clue what's going on. I appreciate for any hints in advanced.

RE: SQL server 2008 R2 backup restore issue

They type of error usually occurs based on the active directory account used to start the SQL Server service. Try this...

Click Start -> Run
Type: services.msc
click OK.

Scroll down to SQL Server, right click, properties, click on the "Log On" tab. The account shown probably does not have permissions to the folder where you put the database files.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

RE: SQL server 2008 R2 backup restore issue

(OP)
yeah, for this related SQL server services, the log on account shows "network services". what account/password supposed to be here? thanks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close