We are usingÃÂ SQL 2005 (SP3) and I have catered a maintenance plan that back ups the database.
I read several articles about the back up of SQL 2005 which confused me and raised few questions in my mind. I am not very familiar with SQL 2005 , so feeling uncomfortable what I am doing for taking the back up of the database.
Every hour our database is pulling data from another server which generates reports and charts for the management. Data volume is fairly huge and must have to have very well planed maintenance in case of disaster we can recover maximum data. Maximum one hour's data loss is appreciated.
Now what I'm doing -
1. Taking backup of our DB once in a dayÃÂ at 12:00AM and
2. Backing up TLog file every hour.
Database back up type if full (Recovery Model: Full). Instead of creating separate backup files, I'm appending the existing file (If Backup File Exist: Append).
For the TLog backup system I'm doing the same - not creating any separate backup file for hourly backup, appending the existing file.
Now my confusions are:
Am I taking the backup correctly, or doing anything wrong (company will be in big risk without any perfect backup plan)
From different articles I found that people suggeste
View Complete Post