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 |
|
Problemkilla
Starting Member
4 Posts |
 Posted - 2002-02-27 : 12:40:41
|
| Currently we are using SQL Backup Maintenance plans to do a combination of full and transaction log backups on our SQL Server. The problem that we are encountering is that as the size and number of the databases grow the backups are causing performance problems for the end users. We backup the databases to disk and then backup the files to tape later at night.I need to know how third party backup programs work vs. internal backup provided within SQL Server. How long does it take to backup a 5GB database? Does it cause any locking issues? Can the databases be running? Do you have any problems with the agents? I need to optimize the speed of the backups.Any information that you could offer would be greatly appreciated. Thanks in advance for your help |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-27 : 13:24:10
|
| Problem with backup utilities is that every time you upgrade sql server you will need to check if there is an upgrade available for the utility and test if it works.Backups are so important that I would keep them as simple as possible i.e. backup to disk then to tape as you are doing. I would not use the maintenance exe as this is complicating things also - but that's a personal opinion, a lot of people use them without problems (and a lot get problems) - it might be worth checking with the profiler what the exe is really doing.I would also copy the backups to another server to restore and check automatically.If you are getting performance problems then you probably should reveiew the design and maybe add more servers.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-02-27 : 13:31:14
|
| There was a presentation at PASS that covered this. I'd see if you can join and download the presentation -- it's free. www.sqlpass.org. The presenter was involved in over 100 distaster recovery situations after 9/11. He said that 62% of third-party SQL Server backups restored OK. He said that 99+% of native SQL Server backups restored successfully.I'd download the prestation and take a look. I'm pretty sure the presenter was Michael Hotek (too many presentations).===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-27 : 13:37:31
|
| I personally prefer native SQL Backups. In my experience they are also faster than 3rd Party Backups.A lot of people use Veritas BackupExec, but really the ONLY benefit to using this is the ability to backup to a remote tape drive.Backing up to disk and moving to tape is typically the most efficient way. What isw your backup schedule? What backups are causing problems, Is it the just the Full, or are the T-Log backups a problem too?-Chad |
|
|
|
|
|
|
Third Party Backup Agents Vs. SQL Backup