SQL Server: How to backup a database
By FoxLearn 6/8/2017 9:57:11 PM 3.48K
How to Backup a database in Microsoft SQL Server
You can backup SQL database from backup tool or run below script to backup
USE Northwind; GO BACKUP DATABASE Northwind TO DISK = 'D:\SQLServerBackups\Northwind.bak' WITH FORMAT, MEDIANAME = 'D_SQLServerBackups', NAME = 'Full Backup of Northwind'; GO
VIDEO TUTORIALS
- SQL Server: How to create Script to Backup database
- SQL Server: How to compare database schemas
- SQL Server: How to restore a database
- SQL Server: How to export data to *.csv file
- SQL Server: How to create a database user
- SQL Server: How to export data to excel file
- SQL Server: How to import data from excel file
- SQL Server: How to use SQL Profiler