Friday, March 22, 2013

Script Backup MS SqlServer

-- Backup Database to .bak File
DECLARE @fileName VARCHAR(90);
DECLARE @db_name VARCHAR(20);
DECLARE @fileDate VARCHAR(20);

SET @fileName = 'D:\backups\'-- change to the relevant path 
SET @db_name = 'my_db';     -- change to the relevant database name 
SET @fileDate = CONVERT(VARCHAR(20), GETDATE(),112);
SET @fileName = @fileName + @db_name + '_' + RTRIM(@fileDate) + '.bak';

BACKUP DATABASE @db_name TO DISK = @fileName; 


sqlcmd -S SQLEXPRESS\AMPER -i "D:\DBA_scripts\backup_database.sql" 

No comments: