Backup Database

,

One of the most important processes for a DBA is backing up and restoring a database.  In its simplest form, a backup can be taken in the following way....

GUI

Right mouse click on the database name, choose tasks and Back up.
 


 

 
Check to confirm the backup location is correct and press OK to start the backup


TSQL

A database can be backed up using TSQL.

BACKUP DATABASE
[AdventureWorks2012]
TO  DISK =
N'C:\DatabaseBackups\[AdventureWorks2012]_FULL_20120209.BAK'
GO

Powershell

A database can be backed up using Powershell

Backup-SqlDatabase -ServerInstance localhost -Database AdventureWorks2012 -BackupFile C:\DatabaseBackups\[AdventureWorks2012]_FULL_20120209.BAK

Rate

Share

Share

Rate