How to create .Bak file of database in sql server using Query

Using SQL Query  wou can create >bak File of given database.
Just try  with given code.
BACKUP DATABASE [Db_Name] TO  DISK = N'E:\LogicalDb_Name.bak'
WITH NOFORMAT,
 NAME = N' Full Database Backup', 
GO
If After one or  Few Minutes you will get message like..
Processed 193200 pages for database 'YourDatabaseName', file 'YourDatabaseName_Data' on file 1.
Processed 1 pages for database 'YourDatabaseName', file 'YourDatabaseName_Log' on file 1.
BACKUP DATABASE successfully processed 193200 pages in 58.383 seconds (21.496 MB/sec).
Then Query Executed .
Just check in your folder whether there is .Bak file is present Or not.

Share This