SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2008
    Location
    london, UK
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL server - trouble restoring a database backup file

    Hi all

    Been stuck on this issue for a while now, i'm trying to restore a database backup file into a new database.....but with no luck.

    I'm using:
    Microsoft SQL Server Management Studio Express v9.0
    SQL server 2005

    And following this tutorial:
    http://www.linglom.com/2008/01/12/ho...l-server-2005/


    I have issues when i reach step 5/6 of the restore process. Please see the attached screenshot. It should display a tree structure of my folders/files, but i get that error message instead. Now, as you can see the path definitely exists, and i've checked my user account and i have administrator privileges, so i'm really not sure what the problem could be

    Appreciate replys

    cheers
    Attached Images Attached Images

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,254
    Mentioned
    113 Post(s)
    Tagged
    1 Thread(s)
    Your user account has access, but how about the service account that SQL Server uses? Right click on the folder itself and select "Properties". Then click on the security tab.

    On my machine, I have a group listed as SQLServer2005MSSQLUsers$myMachineName. That group needs read/write and modify permissions on the folder.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2008
    Location
    london, UK
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by DaveMaxwell View Post
    Your user account has access, but how about the service account that SQL Server uses? Right click on the folder itself and select "Properties". Then click on the security tab.

    On my machine, I have a group listed as SQLServer2005MSSQLUsers$myMachineName. That group needs read/write and modify permissions on the folder.
    Ok just checked that, everything already looks like its setup properly.....yeah? (see attachment)

    One thing i just remembered, my SQL account isn't the main admin account for this program, will this make a difference? (the admin password is unknown)
    Attached Images Attached Images

  4. #4
    SitePoint Enthusiast
    Join Date
    Feb 2008
    Location
    london, UK
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can anyone else help me here?

    I'm a bit new to this, but i've checked the permissions from articles on Google and still have no luck.


    My account should have access to SQL service now


  5. #5
    SitePoint Enthusiast
    Join Date
    Feb 2008
    Location
    london, UK
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SOLVED


    thanks for the help


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •