Discover Top Posts Tagged with #master.dbo.sysdatabases

Simple Database Backup Script

Simple script to create a backup of your SQL Server database:

DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- file date -- specify database backup directory SET @path = 'H:\Backup\' -- specify filename format SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)…