How do I perform a manual Full Database Backup from SQL Server Management Studio?
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:
2) Expand the SQL Instance>Databases and right-click on ksubscribers and select Tasks>Back Up
3) Modify the settings as needed as displayed below:
4) Click OK to begin the backup. This may take some time to complete depending on the size of the Ksubscribers database.