Home » Posts tagged "sql server database backup"

Tag Archives: sql server database backup

Create database backup using SQL query in SQL SERVER


Taking database backup is a day to day operation which database administrators/developers perform. Below is a script for taking database backup in sql server. 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) — used for file name SET @path = ‘C:\DB_Backup’ SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name IN (‘DATABASE_NAME’) OPEN db_cursor FETCH NEXT FROM db_cursor INTO [...]

Tags: , ,