Backup in SQL Server 2012

Asked By 40 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #100769

Backup in SQL Server 2012

qa-featured


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.

Related Questions