There are two different methods to retrieve the list of Primary Keys and Foreign Keys from the database.
I maintain a spreadsheet of questions sent by users and from that I single out a topic to write and share my knowledge and opinion. Unless and until I find an issue appealing, I do not prefer to write about it, till the issue crosses the threshold. Today the question that crossed the threshold is – what is the difference between NORECOVERY and RECOVERY when restoring database and what is the restore sequence.
I assume you all know that there are three types of Database Backup Models, so we will not discuss on this commonly known topic today. In fact, we will just talk about how to restore database that is in full recovery model. Let us learn about backup timeline.
I have been overwhelmed with the request for SQL Server Cheat Sheet recently. I absolutely think it is tremendously useful; its hand written form is adorning my wall since a long time. Having realized its usefulness I got it done professionally and distributed it at TechEd in Hyderabad, TechEd in Ahmedabad, and TechEd on Road in Trivendrum. Now, they are very much in demand.