question

KuldevBhasin-1602 avatar image
0 Votes"
KuldevBhasin-1602 asked Cathyji-msft commented

sql restore 2014

hi. i installed sql server 2014 on my new laptop now when i am restoring the database it is not showing the database name from the backup. the .bak file is working fine on my desktop and older laptop.
i reinstalled the sql management studio again too and also tried giving permission to all the folders but nothing is working.
pls. help.
Thanks Kuldev
127530-sql-restore-error.png


sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KuldevBhasin-1602,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Is that a valid SQL Server backup file at all? By the screenshot it don't look like.
Run a RESTORE Statements - VERIFYONLY (Transact-SQL) command to verify if the backup file is valid

127634-image.png



image.png (55.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @KuldevBhasin-1602,

No backup selected to be restored

Possible reasons and solutions;

1) Backup is corrupted or unreadable: To confirm this, we can run below command

 RESTORE HEADERONLY FROM DISK='complete path to backup file'

If backup is corrupted, we would not be able to see the complete details in the output.

2) Restore to lower version: If a backup is taken on a higher version and restore is attempted to lower version then also we will get the same error.

3) Did your account has the read and write permission for this bak file?

4) Run SSMS as administrator


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.