Perform a Manual Full Database Backup from SQL

QUESTION

How do I perform a manual Full Database Backup from SQL Server Management Studio?

ANSWER

Follow the steps below to manually create a full database backup.

1) Log into SQL Server Management Studio. You will need to either authenticate as your 'sa' account or your Windows Credentials:

7-22-2016_2-30-22_PM.png

2) Expand the SQL Instance>Databases and right-click on ksubscribers and select Tasks>Back Up

7-22-2016_2-31-18_PM.png

3) Modify the settings as needed as displayed below:

7-22-2016_2-33-32_PM.png

4) Click OK to begin the backup. This may take some time to complete depending on the size of the Ksubscribers database.

REFERENCE 

Reference: https://msdn.microsoft.com/en-us/library/ms187510.aspx

APPLIES TO

All versions

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us