April 30, 2010 at 3:06 pm
Hello Guru,
Can anyone direct me and show me the best practice to setup database backup?
Thanks,
Edwin
April 30, 2010 at 3:38 pm
Here's a couple articles:
May 3, 2010 at 6:59 am
Just remember that backups are very largely a business driven decision, not strictly technology. Talk to the business side of the company to understand what their expectactions of your ability to recover their data will be. You have to know their needs before you start making decisions otherwise, you may fail to meet them during an emergency. And that's not the time to find out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2010 at 8:48 am
Grant Fritchey (5/3/2010)
Just remember that backups are very largely a business driven decision, not strictly technology. Talk to the business side of the company to understand what their expectactions of your ability to recover their data will be. You have to know their needs before you start making decisions otherwise, you may fail to meet them during an emergency. And that's not the time to find out.
Good points.
Some databases may be for testing or development and don't change much. They may be ok to backup daily, or even weekly.
Very important production databases may need daily full backups, and transaction log backups every 10 minutes.
Other databases might get refreshed from production data and don't need to get backed up at all if they can easily be recreated.
So, "Best Practice" will vary, depending on your business and the importance of different databases.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply