Backup policy for a 2 TB database.....
what would you recommend exactly and why for each day of the week. what you would do daily, weekly and monthly.
Also, if we have a hardware failure on Wednesday morning what would we need to be able to restore the most recent copy of the database?
Please provide 2 part answers.
Part 1 ) backing up detailed info for hourly, daily, weekly, monthly and yearly for a 2 tb database.
Part 2 ) What is needed to restore the DB if there was a hardware failure on Wednesday morning at 10AM. Assume that we will need all login ID's and DB jobs restored as well.