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 |
|
sanjivus
Starting Member
16 Posts |
 Posted - 2007-08-20 : 14:28:41
|
| Hi to all SQL Gurus,We are running SQL Server 2000 on Win2003 Server. I have 5 databases each having close to 500MB. My goal is to backup all the 5 databases everyday and transfer the files via FTP to another server. I would like to keep backups of last 7 days at my FTP location (DBNAME_MMDDYYYY.bak).I am looking for an automated script for this operation.I have tried so far : I scheduled daily backup for each database. Tried to use winzip to zip the file and ftp to the server. Winzip zips the file and when it tries to ftp to remote server it encounters an error that winzip can not open DBNAME_MMDDYYYY.zip file.I am not able to figure out the reason for winzip error.Any Suggestions.Thanks an Advance. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-20 : 16:18:21
|
| Are you having an error trying to FTP the file, or having an error trying to run WINZIP?CODO ERGO SUM |
 |
|
|
sanjivus
Starting Member
16 Posts |
Posted - 2007-08-21 : 10:12:38
|
| Winzip is able to zip up the file. But when it tries to access the file to do FTP, it throws an error can not access the file DBNAME_MMDDYYYY.zip |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 22:55:35
|
| Did you ftp file in binary mode? |
|
|
|
mverma82
Starting Member
5 Posts |
Posted - 2007-08-27 : 11:23:54
|
| 1st option: you can use Maintaenace plans to do it.2nd option: You can use xcopy and schedule it to do ftp part. Same copy mechanism one use in log shipping.Manish |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-27 : 22:00:00
|
| Those options will not work if servers are not in same domain nor trusted domains. |
|
|
|
|
|
|
Simple Backup Question