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 |
|
Srini.Nichenametla
Starting Member
1 Post |
 Posted - 2012-04-16 : 09:22:29
|
| Application team required database backup to analyse the incidents raised by us. So we have to backup the data, Zip the data and FTP to client location. This process will take 1 hour to do for huge data. We are using SQL Server 2005 version so we can’t use Compress command to compress the data. This command will be using in 2008 version. So Can you please suggest me to simplify this process? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-16 : 10:06:32
|
| You can use a third part backup compression software like Redgate SQL Backup or Quest Litespeed. They won't compress as well as some Zip utilities but they are much faster than backing up and then compressing.By the way, what is "huge data"? Terabytes are going to take hours to transfer via FTP. Do you really need to send a full backup of the database? If you only need to analyze certain tables, use bcp or SSIS to transfer just those tables to text files and FTP those. SSIS can even handle the FTP process in the same package. You can also optionally compress the text files to save space. |
 |
|
|
|
|
|
Data Backup in SQL 2005