How to restore the database in SQL .net project
After the completion the project on the .not how to restore the database on the SQL server Management studio
1. open the new file project on the SQL which file contains the database folder and other folders of the project.
Example i have one project that is railway reservations folder in that abstact , database,etc.,, in database folder cotains 3 files .bak , .mdf, .LDF files. I open the railway reservation folder on SQL server
2. you can get the task by click on the right click button in that you get the restore option final you get the database just see in below
3.After completion the above process you get the below page just click on the from device because you store the database in the harddisk onlythat why click on from device
4. After complition the 2 step you will get the below page which is easily to browse the .bak file simply select where you store in database folder are anywhere else
5. Now you will get the check button just click on that after you click ok button
6. Now you select on overwrite with existing database
7. Now to successfull restore the database into the SQL server management studio
No comments:
Post a Comment