Take Database backup in SQL Server

Introduction: 

In this article we will learn  how to take the backup of SQL server database manually through SQL command/query.

Description: Taking backup of database at regular interval is always recommended to secure data. Sometimes you need to take quick Sql server database backup. So you can use following single line SQL query to take Database backup.

Read More

Take automatic backup of Sql server Database

Introduction:

In this article we will learn  how to take automatic backup of your Sql server database.

sqlcmd -S MYSQLSERVER -Q "BACKUP DATABASE Northwind TO

DISK = 'D:\MyDataBase.bak' WITH INIT, NAME = N'Automatic back up of database',

STATS = 1" 

pause 

Read More