Backup in SQL Server 2012
Asked By
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?
How to create a database backup in SQL Server 2012? Is there any third party software that is recommended?
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.