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 |
|
sqlanon
Starting Member
2 Posts |
 Posted - 2004-04-10 : 23:13:14
|
| I have a company with a 200G database.They say it takes 5 hrs to backup this database locally and have a backup server bound to this server specifically for these backups and it takes 9 hrs.Seems a bit long in both cases what do you think.And would a backup utility help?Not keen on going down the filegroup route but may have to. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-10 : 23:32:30
|
| You might want to look at SQLLiteSpeed. It could very well take that long depending on the speed of your disks and the network speed. We went from a Compaq array to an EMC fiber array and our backup time went from 6 hours to about 35 minutes.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
sqlanon
Starting Member
2 Posts |
Posted - 2004-04-11 : 11:44:05
|
| Thanks, how much data were you talking about? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-11 : 13:42:25
|
| 200gb on weekdays. 300 on weekends.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-12 : 12:17:01
|
| 200GB should not take 5 hours. Before we were using SQL Litespeed on our large databases, it took a couple of hours for similar sized databases. SQL Litespeed cut that time by 60-75%. If you've got more than 2 CPUs, SQL Litespeed can use more than one thread to get the job done.Here is some performance information about SQL Server BACKUPs:http://www.sql-server-performance.com/backup_restore_tuning.aspTara |
|
|
|
|
|
|
Backup performance