Database Backup

Question

sir how can we take backup of database through sql command ?

Senthilkumar · Answer

Hi Shubham Execute the BACKUP DATABASE statement to create the full database backup specifying: The name of the database to back up. The backup device where the full database backup is written. The basic Transact-SQL syntax for a full database backup is: BACKUP DATABASE database TO backup_device [ ...n ] [ WITH with_options [ ...o ] ] ; For example USE AdventureWorks2012; GO BACKUP DATABASE AdventureWorks2012 TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak' WITH FORMAT MEDIANAME = 'Z_SQLServerBackups' NAME = 'Full Backup of AdventureWorks2012'; GO For more info: http://msdn.microsoft.com/en-us/library/ms187510.aspx

Satyapriya Nayak · Answer

Hi Shubham Please refer the below links http://msdn.microsoft.com/en-us/library/ms186865.aspx http://msdn.microsoft.com/en-us/library/ms187510.aspx http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups Thanks