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 |
|
logie0726
Starting Member
17 Posts |
 Posted - 2008-06-26 : 23:02:58
|
| Help! We have an SQL Database at 40G. My problem is when we are processing the sql backup to USB Seagate SATA External 120G it takes long time almost a day. We even cancell the process!But if we are backup on the same harddisk(where the database is located) it only takes 1 hr and half. Any suggestions? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-26 : 23:10:28
|
| Yes that will take longer. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
logie0726
Starting Member
17 Posts |
Posted - 2008-06-27 : 00:00:30
|
| sodeepPlease explain me why? Thanks! |
|
|
|
logie0726
Starting Member
17 Posts |
Posted - 2008-06-27 : 00:01:34
|
| TkizerWhat is your recommendation? TNX! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-27 : 00:04:48
|
| Why don't you want to backup to the local disk? If it's because of disk space, then can you backup to tape? How about using SQL Litespeed?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-27 : 00:05:25
|
| 40GB is not a large database. I'd say that's medium-sized these days. Try dealing with databases that are measured in the terabytes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
logie0726
Starting Member
17 Posts |
Posted - 2008-06-27 : 00:07:03
|
| I use External Backup incase of FIRE or emergency. That all internal Backups cant. Any Idea? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-27 : 00:11:23
|
| There isn't really a way to improve your performance as long as you are using USB 2.0.But what you could do is backup your database to the local disk, compress the file (zip it), and then copy the compressed file to the USB device.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
logie0726
Starting Member
17 Posts |
Posted - 2008-06-27 : 00:21:03
|
| ok! thank you very much... |
|
|
|
|
|
|
Backup Large SQL Server via USB