Post reply

SQL doesn't see .bak file?

  • July 22, 2013 at 11:09 am

    #395179

    Sorry, this is probably a really dumb question, but when I go to do a restore in SSMS, when I get to the step where it asks to locate backup file, my .bak file is not seen in the tree view. I can see the file in explorer, and it has a .bak extension, so I'm not sure why SQL doesn't see it. I am trying to restore a full backup from another server if that makes a difference.

  • July 22, 2013 at 11:39 am

    #1634601

    Your issue is probably file permissions. Try running a script to restore the database and see if it errors out, look for "Access Denied" or "Can't find the file path specified".

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • July 22, 2013 at 12:10 pm

    #1634612

    Thanks for your response. I'll give it a try and let you know.

  • July 22, 2013 at 12:33 pm

    #1634633

    Operating system error 2(The system cannot find the file specified.).

  • July 22, 2013 at 12:48 pm

    #1634643

    1: make sure the path really does exist via windows explorer

    2: make sure the service account has proper permissions to the folder/file

    3: make sure YOU have proper permissions to run the restore command

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • July 22, 2013 at 1:17 pm

    #1634653

    Are you checking that the .bak file exists on the server and not on your desktop?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 23, 2013 at 8:57 am

    #1634993

    Yes, I copied it over to the server I want to restore to. I can see it in Windows Explorer, but SQL is unable to see it. It just doesn't show up in the list. Scripting the restore doesn't work either.

  • July 23, 2013 at 9:01 am

    #1634996

    and the service account has permissions to the file and folder?

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • July 23, 2013 at 9:38 am

    #1635031

    SQL is running as local system. I gave system full permissions to the new folder I copied the backup into. The weird thing is, when I browse for the .bak file, SQL doesn't even see the new folder I put on the C: drive, even though I can see it in Windows explorer.

  • July 23, 2013 at 9:40 am

    #1635035

    Try putting the .bak in the data directory with all your other MDFs if possible.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • July 23, 2013 at 10:09 am

    #1635058

    I'll try that. It'll take probably 30 min. to copy over.

  • July 23, 2013 at 8:03 pm

    #1635185

    Still nothing 🙁

  • July 24, 2013 at 8:56 am

    #1635396

    I think I figured it out. When I right click on the database I want to restore over, select tasks - restore, SQL is unable to find the .bak file. However, when I right click on 'Databases', select 'restore database...", select the database name, then try to locate the file, it sees it!!!

  • October 20, 2014 at 11:12 am

    #1753584

    I am having the same issue.

    Some .bak files are not visible to Restore/Select file. (2008 R2)

    Pasting the path and file name works though.

  • November 3, 2014 at 2:52 am

    #1756282

    Hi,

    I had the same problem and it solved by moving the backup file to the SQL default backup location. This folder didn't have permission and got it when I accessed it for the first time.

    Hope it will work for you as well.

    Regards.

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply