SQLgzip.exe: ??????? ?????????? ??????????? (backup) ?? ??????? ??? ?????? MS SQL Server 2000, 2005, 20008 0.99

? ??????????? ??????? ?????? (????????, gzip, zip, 7zip ?.?.?. ) ????????? ????? (backup) ??? ?????? ????????????, ????? ????????? ????? ????????????? ????????? ???????????? ?/??? ??? ?????????? ??????? ??? ?????????????? ??????? ??? ?????? ?? ?????? ????????. ???????????? ?????? ?? ??????? ????????? ????? ? ?????????????????? BACKUP → ?????? → ??????????? → ?????????? → RESTORE ???????? ?????? ???????? ????????? ? ??????? ??????????????? ????? ?? ?????.

Microsoft ??????? ??????????? ?????? ????????? ????? ??? ?????? ? MS SQL Server 2008 Enterprise Edittion. ??? ????? ??? ??????, ?? ??? ???? ???????? ????????? ??????????:
??“ ????????? ??“ ?? ?????? ??????? ?? Enterprise edition;
??“ ?????? ??????? ?????? ? Enterprise edition (?????? ? ???????????? ?????????????? ?? ?????? ?????????), ?? ??? ??? ? ?????? ????????? ? ???????;
??“ ?????? ?????? ??????????? ? ?????? ????????????? ????????? ?????? ??? ZIP ? GZ ? ?? ????? ???? ?????? ??????????.

SQLgzip.exe ??????? ?????? ????????????? ???? ???????????: ??? freeware ????????? (? ??????? GZ), ????? ???? ???????????? ?? ????? ????????/?????????? SQL Server, GZ ?????? ?????????????? gzip, WinZip ? ?????? ??????????.

???????? ??????????????? ???????? ??“ SQL backup/restore VDI ????????? ? ?????????? zlib. ????????????? ??????? ???? ??????????? ??? SQL server 2000, ?? ??? ????? ???????? ? SQL server 2005 ? 2008, ????????? Microsoft ?? ?????? ??????????? ????????? ? ???????????? VDI ?????????? ? ????????? ????? ????? (backup).

SQLgzip.exe, ??????????? ??? ??????????, ?????? ??????? ??????????.

?????????:
SQLgzip <command> [<database>] <file> ["<WITH_options>"] [<key_options>]

???: <command> - RESTORE, BACKUP, "RESTORE LOG", "BACKUP LOG",
EXTRACT BACKUPFILE|FILELISTONLY|INFOONLY
<WITH options> - backup/restore WITH options
<key_options> SERVER=name - ??? ?????? ???? ??????? ??? ???????? ? instance
MAXTHREADS=n - ?????????: #CPU/2; ??? gz/zip - ????????????
COMPRESSION=n - 1-9; ?? ????????? 1(??????????)

??????????? .GZ ?????????? ??? ??????? Gzip, .ZIP - ??? zip64, ?????? - ???????????
??????????? ?????? ???????????? ??? ??????? ?????????????? ??????.

??????? ?????????????:

SQLgzip Backup master "f:\mssql\master.bar" "WITH DIFFERENTIAL" MAXTHREADS=3
SQLgzip EXTRACT INFOONLY f:\mssql\mydbname.bak.gz @SQLgzip EXTRACT BACKUPFILE f:\mssql\mydbname.bak.gz f:\mssql\master.bak
SQLgzip RESTORE mydbname f:\mssql\mydbname.bak.zip "WITH MOVE 'DataFile' TO 'f:\mssql\data\userdb.mdf', MOVE 'LogFile' TO 'G:\mssql\datalog\userdb.ldf'" SERVER=ERDSQT1F\SQL1
??????? ??? ??????? BACKUP ? RESTORE ????? ????????????. ?? ????? ???????, ??? ?????? ???????? ?????? ???? ???? ? ??????? ???????, ???? ?? ???????? ???????. ????? ????????? ?????????? ???????? BACKUP ??????????? ?????????????? ??????? ???backupmediafamily??? ???? ?????? msdb.

????? ??????? EXTRACT (?????? RESTORE) ???? ???????, ????? ???????? ?????????????? (restore) ??? ?????? ? ??????? FILELISTONLY ??? INFOONLY ? ?????? ?????? ????? ??“ ??? ???? ?????? ??????? ??????? ?????? ?? ?????.

??????? 3 ?????????? ??????? EXTRACT:
1. FILELISTONLY ?????? ?????? ???? ?????? ???? ?????? ? ?????? ????????? ?????: Logical File Name & Physical File Name.
2. INFOONLY ????????? ?????? ???????? ?????????? ?? ?????? ????????? ?????: Backup File, Backup Name, Backup Description,User Name, SQL Server, Backup Start Date, Database Name, Creation Date, Comp. level/version, SortOrder/CodePage.
3. BACKUPFILE ?????? ????????????? ?????? ?«backup?» ? ????????? ????.

?????????? ?????? SQLgzip.exe ???????????? ??????? ???BACKUP??? ? ???RESTORE??? ??? ??????? GZ