Backup in SQL Server 2012

Asked By jcato 40 points N/A Posted on - 08/22/2016

How to create a database backup in SQL Server 2012? Is there any third party software that is recommended?

• Status: Open
• Question Views: 505
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By vadivelan 0 points N/A #100769

Backup in SQL Server 2012

Enterprise Manager is used to create a database backup. You start the SQL server choose backup under task, on right clicking on the database name.Select the DB name in the DB list box, select a backup type from the three available types-full, differential, and transaction log.Then, select the backup component, and specify when the backup set will expire. Add destination of backup. You can also change other settings like reliability, overriding media, etc. No third party software is required.

About vadivelan

Questions
6

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/22/2016
• Question Category: MS SQL Server