Share via

sql restore 2014

Kuldev Bhasin 1 Reputation point
2021-08-30T13:18:39.057+00:00

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 Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2021-08-30T13:26:51.04+00:00

    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

    0 comments
  2. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-08-31T02:45:13.477+00:00

    Hi @Kuldev Bhasin ,

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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.