Simple Microsoft MsSQL server backup DATABASE & LOG batch

IOF>>

@ECHO OFF
SET SUSER=backup_www
SET SPASSWD=XXXXXX

rem date?
FOR /F “TOKENS=2-4 DELIMS=/ ” %%A IN (‘DATE /T’) DO (SET date=%%B%%A%%C)

rem db? filename?

SET db=dbname

SET filename_db=%db%_db_%date%.bak

SET filename_log=%db%_log_%date%.bak

del F:\BACKUP\server.domain\MSSQL\%filename_db%.rar

del F:\BACKUP\server.domain\MSSQL\%filename_log%.rar

OSQL -U%SUSER% -P%SPASSWD% -D server.domain -n -Q “BACKUP DATABASE [dbname] TO DISK = ‘\\machine.domain\F$\BACKUP\server.domain\MSSQL\%filename_db%’”

rar a -m3 -v1G -vn F:\BACKUP\server.domain\MSSQL\%filename_db%.rar F:\BACKUP\server.domain\MSSQL\%filename_db%
del F:\BACKUP\server.domain\MSSQL\%filename_db%

OSQL -U%SUSER% -P%SPASSWD% -D server.domain -n -Q “BACKUP LOG [dbname] TO DISK = ‘\\machine.domain\F$\BACKUP\server.domain\MSSQL\%filename_log%’”

rar a -m3 -v1G -vn F:\BACKUP\server.domain\MSSQL\%filename_log%.rar F:\BACKUP\server.domain\MSSQL\%filename_log%
del F:\BACKUP\server.domain\MSSQL\%filename_log%

Backup Microsoft SCVMM database to file

BackupVMMDatabase.bat

IOF>>

ECHO OFF

rem date?
FOR /F “TOKENS=2-4 DELIMS=/ ” %%A IN (‘DATE /T’) DO (SET date=%%B%%A%%C)

rem db? filename?

SET file=BackupVMMDatabase
SET filename=%file%_%date%.bak

del /Q D:\BACKUP\VMM_DATABASE\%filename%.rar

del /Q D:\BACKUP\TEMP\*.*

rmdir D:\BACKUP\TEMP

mkdir D:\BACKUP\TEMP

C:\Windows\System32\WindowsPowerShell\v1.0\PowerShell.exe -PSConsoleFile D:\BACKUP\BIN\Consola.psc1 -command “. ‘D:\BACKUP\BIN\BackupVMMDatabase.ps1′”

rar_64bits a -ao -ow -m4 -mt4 -rr -rv -v1G -vn -t D:\BACKUP\VMM_DATABASE\%filename%.rar D:\BACKUP\TEMP

del /Q D:\BACKUP\TEMP\*.*

rmdir D:\BACKUP\TEMP

<<EOF

Consola.psc1

IOF>>

<?xml version=”1.0″ encoding=”utf-8″?>
<PSConsoleFile ConsoleSchemaVersion=”1.0″>
  <PSVersion>1.0</PSVersion>
  <PSSnapIns>
    <PSSnapIn Name=”Microsoft.SystemCenter.VirtualMachineManager” />
  </PSSnapIns>
</PSConsoleFile>

<<EOF

BackupVMMDatabase.ps1

IOF>>

# Description: Backs up the VMM database.

# Specify the VMM server and domain.
$VMMServer = Get-VMMServer -ComputerName “sek-wmm-02.grupo.sek”

# Specify the backup folder path and name. To back
# up a database to a network share, specify the UNC
# path, for example, \\SQLServer01\VMMBackups.

Backup-VMMServer –Path “D:\BACKUP\TEMP” -VMMServer $VMMServer

<<EOF

Script .BAT para hacer backup DATABASE & LOG de una base de datos MsSQL en Windows

Este Script permite realizar una tarea de backup de una base de datos de MsSQL en caliente en una máquina windows.

Para correr este BAT es necesario:

-Tener instalado o el comando con sus respectivas librerias osql.exe

-Tener el ejecutable de Winrar Rar.

IOF>>

@ECHO OFF
SET SUSER=backup_www
SET SPASSWD=XXXXXX

rem date?
FOR /F “TOKENS=2-4 DELIMS=/ ” %%A IN (‘DATE /T’) DO (SET date=%%B%%A%%C)

rem db? filename?

SET db=dbname

SET filename_db=%db%_db_%date%.bak

SET filename_log=%db%_log_%date%.bak

del F:\BACKUP\server.domain\MSSQL\%filename_db%.rar

del F:\BACKUP\server.domain\MSSQL\%filename_log%.rar

OSQL -U%SUSER% -P%SPASSWD% -D server.domain -n -Q “BACKUP DATABASE [dbname] TO DISK = ‘\\machine.domain\F$\BACKUP\server.domain\MSSQL\%filename_db%’”

rar a -m3 -v1G -vn F:\BACKUP\server.domain\MSSQL\%filename_db%.rar F:\BACKUP\server.domain\MSSQL\%filename_db%
del F:\BACKUP\server.domain\MSSQL\%filename_db%

OSQL -U%SUSER% -P%SPASSWD% -D server.domain -n -Q “BACKUP LOG [dbname] TO DISK = ‘\\machine.domain\F$\BACKUP\server.domain\MSSQL\%filename_log%’”

rar a -m3 -v1G -vn F:\BACKUP\server.domain\MSSQL\%filename_log%.rar F:\BACKUP\server.domain\MSSQL\%filename_log%
del F:\BACKUP\server.domain\MSSQL\%filename_log%

 <<EOF