InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
I Have All The Primary Data Files, Secondary Data Files As Well As Logs. Now, Tell Me Can I Still Restore The Database Without Having A Full Backup? |
|
Answer» You cannot restore the database without having a FULL database BACKUP. However, if you have the copy of all the DATA files (.mdf and .ndf) and logs (.ldf) when database was in working condition (or your desired state) it is POSSIBLE to attach the database using sp_attach_db. You cannot restore the database without having a full database backup. However, if you have the copy of all the data files (.mdf and .ndf) and logs (.ldf) when database was in working condition (or your desired state) it is possible to attach the database using sp_attach_db. |
|