ross13
asked on
Restore SQL server 2005 database from mdf file
Hi,
I tried to restore a sql server database using the .bak file and received an error looking for a .MDF file.
Any help on how to do a restore would be great. Its a full backup and i need to restore / create a new database from it.
Regards,
Ross
I tried to restore a sql server database using the .bak file and received an error looking for a .MDF file.
Any help on how to do a restore would be great. Its a full backup and i need to restore / create a new database from it.
Regards,
Ross
Hi,
Right Click on Databases -> Restore DataBase -> write a DB name there -> SELECT THE FROM DEVICE radio button -> select backup -> tick the Restore checkbox -> OK
DBRESTORE.png
Right Click on Databases -> Restore DataBase -> write a DB name there -> SELECT THE FROM DEVICE radio button -> select backup -> tick the Restore checkbox -> OK
DBRESTORE.png
Did you checked the Restore As path .... is it a valid path ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
can you share your error screen shot....
- Bhavesh