forum.lissyara.su

Код: Выделить всё

BACKUP DATABASE [test] TO  DISK = N'D:\!backup\MSSQL\test.bak' WITH NOFORMAT, NOINIT,  NAME = N'test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

Код: Выделить всё

:: Путь к исполняемым файлам
SET PATH_BACKUP=Z:\backup_SQL
SET PATH_SQL=C:\Program Files\Microsoft SQL Server\90\Tools\Binn

:: Указываем путь для бэкапа
SET BACKUP_DISK=d:
SET BACKUP_DIR="D:\!backup\MSSQL\%date:~-7%"
SET DIRNAME=%date:~-7%

:: Проверим путь назначения архива
%BACKUP_DISK%
if not exist \!backup md \!backup
if not exist \!backup\MSSQL md \!backup\MSSQL
if not exist \!backup\MSSQL\%DIRNAME% md \!backup\MSSQL\%DIRNAME%

:: Выполняем БЭКАП
"%PATH_SQL%\SQLCMD" -S COMP\SQLEXPRESS -i "%PATH_BACKUP%\backup.sql"

cd "%BACKUP_DISK%\!backup\MSSQL"
"c:\Program Files\WINRAR\winrar" a -agYYYY.MM.DD_hhmmss -m1 "%BACKUP_DIR%\test_.rar" "test.bak"
del "*.bak"

Код: Выделить всё

set backupname=c:\temp\delme\pg_%dbname%_%cdate%.backup

echo %hostname%\%dbname% - %backupname%



echo ======================================================================== >> %logname%

echo | date /t >> %logname%

echo | time /t >> %logname%

echo %hostname%\%dbname% - %backupname% >> %logname%



if exist %backupname%_.bak del %backupname%_.bak

if exist %backupname% rename %backupname% *.backup_.bak

Код: Выделить всё

DECLARE @to varchar(3000)
DECLARE @dbname varchar(50)
DECLARE @path varchar(350)

set @dbname = 'ITMarchive'
set @to = 'S:\BACKUP_DB\'
set @path = @to + @dbname + '_' +
cast (DATEPART(weekday, GETDATE()) as varchar(1)) + '.' +
cast (year(getdate()) as varchar(4)) + + '.back'

backup database @dbname to disk=@path with init

Код: Выделить всё

@echo off
SET ARCDIR=C:\BKP
SET EXE=C:\BKP\7Z\7Z.EXE
SET SQLEXE="c:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
SET SQLCMD=BACKUP DATABASE BSS TO DISK

for /F "TOKENS=1,2 delims=: " %%A in ('time /t') do set CURT=%%A-%%B
%SQLEXE% -E -Q "%SQLCMD% = 'C:\bkp\bss_base_full_%date%_%curt%.bak'"
%EXE% A -mx=3 %ARCDIR%\base_full_%date%_%curt%.7z %ARCDIR%\bss_base_full*.bak
del c:\bkp\bss_base_full*.bak
copy /y c:\bkp\*.7z \\backup\bk\  && move /y c:\bkp\*.7z \\bk1\bk\