I have few questions with respect to consistency check before backup - around 4 options are available - physical media, full checkup excluding indexes, full checkup including indexes, none.
Question 1 What will be the difference between them.
Question 2 I tired selecting the Adventure database while backing up, only the adventures with the backup option as full checkup excluding indexes. But when i restore the database it lists the adventure database, along with master, model, msdb, report server, pls find the attachemnt.Does it is related to indexes.
Question 3 How can i verify the index options in backup
Experts request you to guide me in the options of BE 2012.