I have 3 databases, backups and logs in hand: MDF, NDF, LDF. Which one should I use to recover my database information?
• MDF is for SQL Server Master Database File • NDF is for SQL Server Secondary Data File • LDF is for SQL Server Transaction Log File Recovery for SQL Server requires MDF file to recover database, backup and log. If you don’t have an MDF, there’s no way to restore your data. In case you have an NDF, please, place it in the same directory as MDF before processing with data recovery: Recovery for SQL Server will use it to improve the quality of recovery as much as possible. LDF file is not necessary at all.
Related Questions
- To recover the PROD database, you need to apply a large number of archived logs. Which command would you issue to automatically apply the archived logs when the recovery process is started?
- To recover the PROD database, you need to apply a large number of archived logs. Which command would you issue to automatically apply the archived logs when the recovery process is started?
- I have 3 databases, backups and logs in hand: MDF, NDF, LDF. Which one should I use to recover my database information?
- Does the MiMiC v3 Delta Database Generator work with the databases that use encrypted class-based modules?
- What are the benefits of embedded databases?
- What are the benefits of embedded databases?
