SOLVED

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

Copper Contributor

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.

 

 

2 Replies
best response confirmed by Javier Villegas (MVP)
Solution

 


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.

@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.

1 best response

Accepted Solutions
best response confirmed by Javier Villegas (MVP)
Solution

 


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.

View solution in original post