March 25, 2009 at 11:42 am
The question is whether the "backup exec" can perform the transactional, differential and of course the full backup for / on a database with various scheduled execution times. For instance, do transactional every 1 hours, differential daily and full back up on Sundays?? !!!
Now, what I am interested, additionally of course, is that whether backup exec is adding more load to the system or not and whether is going to affect the system performance in general.
I need to make that decision today before switching to BE from task oriented 3 way backup process natively that is in place today, on my databases.
Cheers,
John Esraelo
March 25, 2009 at 4:46 pm
not entirely sure what backup exec is capable of, would not be surprised if it cannot do differentials.
One thing I am sure of, there is no way it does a better job than native backups, especially when it comes to restoring them!
---------------------------------------------------------------------
March 25, 2009 at 5:10 pm
Thank you for the reply! Good point and I have discussed this with Symantec and they were trying to tell me that it's capable of doing it.
I believe, based on what I heard from the tech, the software basically backsup the file(s) based on the crc and parity change, therefore, it sound like there is only once kind of file backup anyway that the running agent give or fires up an even to backup the file(s).
So, I am not sure how BE works really.
I do not feel comfortable with the BE only. I rather backup my databases, 3 types, copy those files elsewhere (just in case) and have BE backup the copy of the backup file(s). That way, there won't be any conflicts and file-in-use error(s).
What do you think?
Cheers,
John Esraelo
March 26, 2009 at 7:28 am
In the one or two places I've been that have had backup exec (or similar) the SQL Agent has been put in place and configured by none dbas who have not understood the nuances of what they are doing, and the restore process worried me to say the least. So in those cases I have set up native backups and put my trust in them.
It is an accepted practice to use native backups to local(or SAN) disk and use the backup tool to pick up the backups and offsite them.
where these tools have a use is if the database is very big and you lack disk space for backups, then you can use them to backup to virtual device.
I would never rely solely on them for system database backups, though they could have a use in doing file backups of the resource database.
---------------------------------------------------------------------
March 26, 2009 at 9:08 am
love the answer.... I can not agree more...
thank you again during my lapse of reasoning.. appreciate it.
I am sure I will be picking your brain again and again..
Cheers,
John Esraelo
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply