Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crwenger
Starting Member
2 Posts |
 Posted - 2008-11-21 : 13:18:51
|
| Hi,I'm looking for breakdown of best practices for backing up an instance of SQL Server 2005 using Backup Exec 12d remote agent. Any help greatly appreciated. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-11-21 : 13:47:42
|
| You'll find all the breakdowns when you try to do a restore (which you should test at least once per quarter).Best practices around backup/recovery will usually be independent of the package used to do the backups. If the databases are small, you may as well do a full backup every night. If point in time recovery is required, get the transaction logs backed up a number of times per day (this may be dependent on other backup jobs, and/or performance). Read up on and understand recovery models in SQL Server Books Online (BOL). |
 |
|
|
|
|
|
SQL Server and Backup Exec 12d