Click Ok once the backup is completed successfully.Click Ok Locate Database Files window and then click Ok to close the 'Select Backup Destination' window.Take note of the path where the backup file will be created. This will be the name of the backup file once the backup is complete. In the 'File name' field at the bottom of the 'Locate Database Files' window, enter the desired path and backup file name.Click the ellipse button to the right of the 'File name' field.If a file path does not exist in the window, click the Add button.If a file path already appears in the 'Destination' window at the bottom, take note of the path and name of the backup file that will be created.Right-click the database that you would like to backup and select Tasks -> Back Up.Login as SA or an SA equivalent account.Open SQL Server Management Studio on the existing Client Management Microsoft SQL database server.