Backup baz SQL Server Express i Firebird na Windows

SqlExpress

[code]osql -S server\nazwainstancji -E -Q "BACKUP DATABASE nazwabazydanych TO DISK=’e:\BACKUP_SQL\nazwabazydanych_%date%.bak’ WITH FORMAT" >> e:\BACKUP_SQL\nazwabazydanych_%date%.txt
forfiles /m *.* /p e:\BACKUP_SQL\ /c "cmd /c del @file " /d -4 [/code]

Firebird

[code]"C:\Program Files (x86)\Firebird\Firebird_2\bin\gbak" -user user1 -password test -b >> C:\data\Z.gdb e:\backup\data\Z_%date%.gbk
forfiles /m *.gbk /p e:\backup\data\ /c "cmd /c del @file " /d -4[/code]

Ściąganie z FTP

[code]"C:\Program Files (x86)\GnuWin32\bin\wget.exe" -N -r –tries=5 –ftp-user >>backup –ftp-password password_ftp –no-dns-cache ftp://ip_ftp/zasób/ 2>> c:\skryptybackup\backup.log[/code]

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>