Backup Database

Introduction

Use this to backup your databases and free up room on servers.

Usage

@BACKUP is where it's going be @DBName is the name of the database

DECLARE @BackupPath NVARChar(255)
DECLARE @DBName NVARChar(255)

SET @BackupPath = N'\\Server\User\FileName.bak'
SET @DBName = N'DatabaseName'

BACKUP DATABASE @DBName
TO DISK = @BackupPath
WITH
    NOFORMAT,
    NOINIT,
    NAME = @DBName,
    SKIP,
    NOREWIND,
    NOUNLOAD,
    COMPRESSION,
    STATS = 10
GO

Contribute

Submit a pull request