I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of the solutions :-
1) If a database goes down for whatever reason (assume data file is corrupt) and the database cannot be brought back online (i.e. you are in a recovery situation), what must be done first to ensure you can retrieve the latest data modifications assuming the database is set to the FULL recovery model?
ans :- meanwhile connect to the log shipping server.
2) What can you do to guarantee any backup is valid?
ans :- restore verifyonly from backup
3) What special type of page within SQL Server that is responsible for tracking (via a simple bitmap) extents that have been modified since the last "BACKUP DATABASE" statement?
I had more questions to ask ,wenever i recall, i will again post here only.