Sql query For Creating .bak file in sql server 2005/2008 | with Full Database Backup

 Create .bak file of database within minute with extra features
BACKUP DATABASE [DB_Name] TO  DISK = N'E:\DBLogicalName.bak' WITH NOFORMAT, NOINIT,  NAME = N'Single-Full Database


Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

Share This