Restore database

mohit_vashishtha · November 8, 2016, 10:36am

Hi Sir

I want Restore database backup in sql erver 2014.

when i select restore database then one message show in top of window No backupset selected to be restored.

Please anyone tell me how to restored databse.

TITLE: Microsoft SQL Server Management Studio

No backupset selected to be restored.

BUTTONS:

SowkarthikaNAV · November 8, 2016, 11:40am

Did you select appropriate .bak file ? Try selecting Cronus backup file to restore and check if it works.

mohit_vashishtha · November 9, 2016, 4:34am

My latest database backup .bak file was corrupted. Thanks

Akkrahul · November 9, 2016, 12:41pm

hii
i think ,if you have Ldf,Mdf file related database then ,you can attach the database using sql server database (must have ldf,mdf file)

SARAVANANS · November 21, 2016, 12:33pm

Just check whether the backup is taken from SQL higher version like 2016 and trying to restore in lower version.