You can simply velidate the backup files integrity by restore verifyonly option.

http://msdn.microsoft.com/en-us/library/ms188902.aspx

Check this.

http://msdn.microsoft.com/en-us/library/ms191545.aspx

welcome!!:-)

Use Output Parameter in your Stored Procedure.

http://msdn.microsoft.com/en-us/library/ms378108.aspx

same issue.

http://www.sqlservercentral.com/Forums/Topic587783-148-1.aspx

There is no issue for configuring mirroring on all your databases.

this article may help you.

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx

Have you tried opening the same trace file using Sql server profiler?

Nice Article!!

you can only find modified date.. for history of changes you can use source control or ddl trigger.

Use WITH REPLACE in the RESTORE command.

I also using same to get rid of repeated notification.

You can find it through SQL agent error log.

you can refer this Book MCTS Self-Paced Training Kit (Exam 70-432)

http://www.microsoft.com/learning/en/us/book.aspx?id=12858&locale=en-us

Nice blog on query cost.

http://sqlblog.com/blogs/rob_farley/archive/2010/03/09/t-sql-tuesday-query-cost.aspx

Scheduling SQl Agent Job.

http://msdn.microsoft.com/en-us/library/ms191439.aspx