SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com

Backup Database SQL Server

6. In Backup Component select Databases and in Backup set leave the default Name and optionally enter Description. Leave the default value as 0 days for Backup set will expire after option.

Take Full Backup of Database in SQL Server Using SQL Server Management Studio (SSMS)

Step 7. Click the Add button to select the file or backup device for the backup destination as shown in the below snippet and click OK to return to Backup Database Dialog box.

Select the Database Backup Destination in SSMS

Step 8. Once you have completed the General settings you will be able to see a screen similar to below snippet.

Step 9. Select Options in the Select a page pane to view the advanced options. In Overwrite Media choose Back up to the existing media set and Append to the existing backup set option as shown in the below snippet.

Step 10. Under Reliability section, you can select the checkbox Verify backup when finished option. By selecting this option you can make sure the database backup is good.

Backup Database Options Page in SQL Server Management Studio

Click the below Number Buttons to continue reading the rest of the article.

Chetna Bhalla


Chetna Bhalla, the founder of MyTechMantra.com, believes that by sharing knowledge and building communities, we can make this world a better place to live in. Chetna is a Graduate in Social Sciences and a Masters in Human Resources and International Business. She is an alumnus of Vignana Jyothi Institute of Management, Hyderabad, India. After graduation, Chetna founded this website, which has since then become quite a favorite in the tech world. Her vision is to make this website the favorite place for seeking information on Databases and other Information Technology areas. She believes that companies which can organize and deploy their data to frame strategies are going to have a competitive edge over others. Her interest areas include Microsoft SQL Server and overall Database Management. Apart from her work, Chetna enjoys spending time with her friends, painting, gardening, playing the violin, and spending time with her son.

Newsletter Signup! Join 15,000+ Professionals

Be Social! Like & Follow Us

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.