Let me know this one ---- Suppose my DB gets corrupted(after taking the backup)? For restoring the database which files i required to have? Is the backup file *.bak is only enough to restore or else we also have necessary of .mdf, .ldf files.
Thank U all,
You can create a new blank database and restore it from the .bak file you have. you can delete the currepted database and keep the newly created DB.