Please help me with details on
1.how i can automate a job to go ahead and restore a specific database from one server to another every month so that i can be sure that the backups are valid.
2.Once done, I would like to run checks on it. Please provide a list of database validation checks that should be performed. Is a basic health check sufficient???
3.Send myself and email and drop the restored db.
Thanks in advance!
View Complete Post