Forum Discussion

Shahid2000's avatar
Shahid2000
Copper Contributor
Dec 28, 2023
Solved

Have issues connecting my .bak file to SQL Server (using SSMS)

Hi there,

I am very new to this SQL and SSMS.  I have downloaded the SQL Express and SSMS 19.2. 

I have downloaded the "KCC Sample Database.bak" as a database file to practice on SQL Server.

 

I went into SSMS, in the Object Explorer, I connected to SQL Server.

R/c Databases --> Restore Database

Under Source --> Device --> and then browse

While Backup Media Type as "File" selected, I clicked on "Add"

 

In the Browse, I made sure that I have "All Files" selected in the lower right hand side.

 

I know where I have placed the Backup file but cannot see it.

 

Please help, step by step since I am very new in this.

 

Also, at one point I was getting the following error as well:

 

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.

 

Thanks, I would appreciate it.

 

Shahid.

 

 

  • olafhelper's avatar
    olafhelper
    Dec 29, 2023

     

    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

    Shahid2000 , where have you placed the backup file?

    Keep in mind, not "you" accesses the backup file, it's the SQL Server service account and if you stored the BAK file somewhere in your profile folder, the account can't access it.

    Move the BAK to the backup folder of SQL Server.

2 Replies

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Dec 29, 2023

     

    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

    Shahid2000 , where have you placed the backup file?

    Keep in mind, not "you" accesses the backup file, it's the SQL Server service account and if you stored the BAK file somewhere in your profile folder, the account can't access it.

    Move the BAK to the backup folder of SQL Server.

    • Shahid2000's avatar
      Shahid2000
      Copper Contributor
      Jan 02, 2024

      olafhelper 

      Hi there,

      Thanks for your help.  I appreciate it.,

      Yes, I was able to access and see the backup after going into specifically SQL Server Configuration and Refreshing that.

       

      Thanks for your help anyways.  I do appreciate this a lot.

       

      Take care.

       

      Shahid.

Resources