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 |
|
jerrysql
Starting Member
2 Posts |
 Posted - 2012-10-19 : 11:28:23
|
| Hello, I am struggling a tad on sql backups and restores. We are using Simple mode and backing up the DBs through Backup Exec. I am aware that if we have an issue with a db and I do a restore from last night in example, that I would lose everything from today etc...What do I need to do to accomplish SQL backups, a sql db restore and be able to "replay" transaction logs if needed. If I lose my SQL DB today but I still have transaction logs, I want to be able to restore my SQL db from last night and then be able to replay the trans logs from today because they didnt get corrupted..? Do I need to have a special program to be able to "replay" trans logs back into the DB?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-19 : 12:00:12
|
| First thing is to change your recovery model to Full or Bulk-Logged (Full is better), otherwise you can't back up the log. Next is to set up BackupExec to perform transaction log backups, if it supports that. The frequency of log backups is up to you, but every hour is a good start, or every 15 minutes if you have a busy database.You need to test your backups on a different server to be sure they can be restored. This includes full and log backups. You would use the NORECOVERY option to restore a sequence of backup files to restore to a point in time. The syntax for the RESTORE command is covered here: http://msdn.microsoft.com/en-us/library/ms186858.aspx If BackupExec doesn't support log backups, or restoring with NORECOVERY, you're better off not using it at all. You can use SQL Agent Jobs to do full and log backups and schedule them appropriately. Backup files can be placed in a folder and BackupExec can copy those files to another location for safekeeping. |
 |
|
|
jerrysql
Starting Member
2 Posts |
Posted - 2012-10-22 : 09:14:05
|
| Thanks for the info. |
|
|
|
jaydeeps
Starting Member
1 Post |
Posted - 2012-10-23 : 09:19:06
|
| Make changes as robvolk has suggested. And i can confirm that Backup Exec does support Log backups and point in time restores (NORECOVERY). |
|
|
|
|
|
|
db backups and restores