March 19, 2014 at 3:19 pm
dbalmf (3/19/2014)
SqlBuddy123.. Mind If I grab that script..? I was just starting to write something like that.. 😀
Sure, No Problem ..
--
SQLBuddy
March 25, 2014 at 7:05 am
Hello --
The rescheduling of the third-party backup job resulted in the native differential backup being successful. Even though the third-party backup include any of the database bak or trn files, it did include the log files for the database server application, and somehow that was affecting the native backups.
I am going to contact the vendor about this, and see what its representatives have to say about it. Meanwhile, I am going to reconfigure the backups so the problem does not occur again. Thanks to everyone for your help on this.
I did have a follow-up question: One of the purposes of the backup was to have the SQL Server log files backed up to tape. Is there a better way of preserving these log files?
March 25, 2014 at 7:59 am
kaplan71 (3/25/2014)
Hello --The rescheduling of the third-party backup job resulted in the native differential backup being successful. Even though the third-party backup include any of the database bak or trn files, it did include the log files for the database server application, and somehow that was affecting the native backups.
I am going to contact the vendor about this, and see what its representatives have to say about it. Meanwhile, I am going to reconfigure the backups so the problem does not occur again. Thanks to everyone for your help on this.
I did have a follow-up question: One of the purposes of the backup was to have the SQL Server log files backed up to tape. Is there a better way of preserving these log files?
Can the third party system be configured to exclude files with the extensions ldf, mdf, and ndf? Or, better, to exclude the directories in which these files exists?
March 25, 2014 at 8:11 am
kaplan71 (3/25/2014)
Hello --The rescheduling of the third-party backup job resulted in the native differential backup being successful. Even though the third-party backup include any of the database bak or trn files, it did include the log files for the database server application, and somehow that was affecting the native backups.
I am going to contact the vendor about this, and see what its representatives have to say about it. Meanwhile, I am going to reconfigure the backups so the problem does not occur again. Thanks to everyone for your help on this.
I did have a follow-up question: One of the purposes of the backup was to have the SQL Server log files backed up to tape. Is there a better way of preserving these log files?
It's better to take the TL backups to the local drive \ Ntk drive and then use the 3rd part software to move those files to the tape. This way you can avoid any additional backups by that 3rd party tool.
--
SQLBuddy
March 26, 2014 at 7:08 am
Hello --
The third-party backup program can be configured to exclude the directory where the log files reside.
That brings me to another question: Correct me if I am wrong, but it would seem to me that backing up the log files is good practice. If I do not use the third party utility to back up the log files, what can I use to do this task without interfering with database server operation?
March 26, 2014 at 7:23 am
Hi There,
It depends on the recovey model the database uses, full or bulk, backup the logs. In simple there is no need to back them up.
Eariler in the thread I can see you are backing the transaction logs up, why not just backup the directory the backups are written to?
March 26, 2014 at 7:58 am
kaplan71 (3/26/2014)
Hello --The third-party backup program can be configured to exclude the directory where the log files reside.
That brings me to another question: Correct me if I am wrong, but it would seem to me that backing up the log files is good practice. If I do not use the third party utility to back up the log files, what can I use to do this task without interfering with database server operation?
File system backups are not necessarily viable backups. Using native SQL backups or 3rd party SQL Backup solutions to backup the databases to disk and then backing up those backup files using a file system backup is the way I would chose to go.
March 26, 2014 at 9:08 am
kaplan71 (3/26/2014)
Hello --The third-party backup program can be configured to exclude the directory where the log files reside.
That brings me to another question: Correct me if I am wrong, but it would seem to me that backing up the log files is good practice. If I do not use the third party utility to back up the log files, what can I use to do this task without interfering with database server operation?
It's a precautionary step from the server point of view which helps in the quick recovery. But it should in no way interfere with your normal SQL operations or break the DB backup chain.
--
SQLBuddy
Viewing 8 posts - 31 through 37 (of 37 total)
You must be logged in to reply to this topic. Login to reply