| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2006-08-10 : 11:44:25
|
| Hi All,I am looking for a backup/restore tool to replace with built-in SQL Server's backup/restore utility. I am specifically looking for those of you whom has one of these tools in his/hers environment. I love to hear your experience about it. Thanks a bunch!Canada DBA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-10 : 12:20:16
|
| I always use t-sql - too much risk for anything else.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2006-08-10 : 12:46:40
|
Doesn't it impact your server's performance?quote:
Originally posted by nr
I always use t-sql - too much risk for anything else.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
Canada DBA |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-10 : 14:02:01
|
quote:
Originally posted by CanadaDBA...Doesn't it impact your server's performance?...
Usually not as much as losing the database without a backup.CODO ERGO SUM |
|
|
|
CanadaDBA
583 Posts |
Posted - 2006-08-10 : 14:54:25
|
| Well, I didn't mean that. But I am looking for a better tool with less impact on my servers and faster backup/Restore.Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-10 : 14:55:53
|
| Backups don't impact performance on my servers. On our larger databases, we use SQL Litespeed for faster backups and smaller file sizes.Tara Kizer |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-10 : 19:43:52
|
| We are using NetBackup from Symantec for our enterprise solution. Backing up to tape library is no complaint about that but the backup to single tape, we have minor issue. But other than is good. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-10 : 22:27:44
|
quote:
Originally posted by CanadaDBA
Well, I didn't mean that. But I am looking for a better tool with less impact on my servers and faster backup/Restore.Canada DBA
Any backup tool you use is going to still be using SQL Server's backup routines.Tape backups and tools like LiteSpeed are just piping the output from backup onto a tape or file.I would stay away from disk or volume based methods, like EMC BCV backups, bacause they are not real SQL Server backups, and they are very hard to manage and recover a database from.If your backups are badly impacting application performance, you should look at faster hardware.CODO ERGO SUM |
|
|
|
CanadaDBA
583 Posts |
Posted - 2006-08-11 : 10:49:28
|
| Any backup tool you use is going to still be using SQL Server's backup routines.Tape backups and tools like LiteSpeed are just piping the output from backup onto a tape or file.These are interesting. I am learning. I didn't know that these tools are using the same routines. But how come they make the backup faster and even with smaller size? I get backups after business hours and it really doesn't hurt my applications. My thought is to have ability for faster restore in case of a problem arises. Also, I need a full backup within half an hour BEFORE the business starts. Is it possible somehow to improve speed of built-in backups?Thanks,Canada DBA |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-11 : 18:10:32
|
| >> "But how come they make the backup faster and even with smaller size?"LiteSpeed pipes the data into a compression routine and compresses it on the fly. It gains speed by having to write less data to the disk. The backup that LiteSpeed creates can be uncompressed into a regular SQL Server backup file.CODO ERGO SUM |
|
|
|
CanadaDBA
583 Posts |
Posted - 2006-08-14 : 13:27:06
|
| Does all backup tools, i.e. LiteSpeed, Red-Gate SQL Backup, SQLsafe, use the same idea? Is it possible somehow to speed up the built-in backup/restore utility? Generally, is there some techniques that a DBA can get backup faster and with less impact on users?Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-14 : 13:47:18
|
quote:
Originally posted by CanadaDBA
Does all backup tools, i.e. LiteSpeed, Red-Gate SQL Backup, SQLsafe, use the same idea? Is it possible somehow to speed up the built-in backup/restore utility? Generally, is there some techniques that a DBA can get backup faster and with less impact on users?Canada DBA
http://www.sql-server-performance.com/backup_restore_tuning.aspTara Kizer |
|
|
|
|
Backup/Restore Tools