DosTips.com

Sorry I may not have made myself clear enough.. The current backup system I have in place automates a backup of my sql database and it labels it "Backup 1" and everytime the backup takes place it finds the next available number which is fine.. So on Monday I backup and it saves as Backup 1...

Do all the files go into one folder? Yes all the files will goto the corresponding customer file Are the files named by date and time? No the backup files only have the number of which backup up it is, for example if we started this on 1st of Jan and ran it through till the end of the year we would ...

Username and password are case sensitive try this: @echo off set "ftpScript=%temp%\%~nx0.ftp.tmp" ( echo open 188.39.138.35 echo Customer echo Test1 echo prompt echo bin echo CD "/public/customer backups/" echo mput "C:\FocusBackup\*.bak" echo quit ) > "%ftpScript...

Ok, so bear with me.. The FTP IP = 188.39.138.35 The username = Customer The password = Test1 And the files I want to copy are located at C:\FocusBackup\ And the location I want the files to go are m backups/ So if I understand it, it should look something like this.. @echo off set "ftpScript=%...

Yeah, and Im struggling to understand on how to go about it, I understand having to write the login credentials, but the ftp server name, is that just the ip address? or the path to where I want the file to go? @echo off set "ftpScript=%temp%\%~nx0.ftp.tmp" ( echo open (ftp server name) ec...

Iv looked on here and various websites and im really struggling. :\ @echo off color 0A @REM - Schedule this to run in Control Panel, Scheduled Tasks @REM - Auto number backup filename SET Server=.\SQLInstance SET DBName=SQL SET BackupPath=C:\SQLBackup SET BackupName=SQLBackup SET Ext=bak SET i=0 @RE...

xcopy /c /k /o /v /y "C:\FocusBackup\*.bak" "ftp://XXX.XX.XX.XXX/public/SQLBackup/Company/" xcopy doesn't support FTP file transfers You'll need to write an FTP script and use ftp.exe when using native tools. Ill probably sound a bit silly, but im new to this could you point me ...

Hi All, My aim goal is to write a batch file that will create a SQL backup of a database, and then upload it remotely without any user interaction. I have created a batch file which will create the SQL backup and it will save it in the location that I have specified.. I then played around and Im abl...