Related Posts Plugin for WordPress, Blogger...

About

Follow Us

Showing posts with label Databse Backup. Show all posts
Showing posts with label Databse Backup. Show all posts

Friday, 6 February 2015

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.

Thursday, 5 February 2015

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