VT3000 - Back Up Database - SQL Server

From Versacall Support
Jump to navigation Jump to search
Call Now 858-677-6766 SubmitTckBtn.png EmailUsBtn.png



GeneralHeader.png

Overview
For this method to work properly, you must physically access the VersaCall computer or the Server that is storing the databases. You must create a folder to store the backup files to on the VersaCall Computer or Server storing the databases.


Requirements
See Requirements Here
1. The VT3000 Core Software installed and running on your system.
2. The Databases must already exist in your SQL Server Instance.
3. Working knowledge of SQL Server or SQL Server Management Studio
4. A backup file saved to the Computer/Server that the SQL Server Instance is running on.
5. SQL Server Management Studio installed on the Computer/Server running the SQL Server Instance or on a computer that can access the computer from your network.
6. SQL Server Instance name (IP Address/Computer Domain Name & SQL Server Instance Name).
7. SQL Server Instance login (Username & Password).



InstructionHeader.png

Step 1.
Open the VT3000 web-interface - select VT3000 - select Administration - select System Settings - select Global.
3114 1.png
Icon systemsettings.png
Icon globalsettings.png
Administration System Settings Global



Step 2.
Under the Database Locations heading, expand the details for one of the databases.
Global2.png



Step 3.
If the SQL Server Name field looks like the image below, you will need to access the VersaCall computer. User Name & Password will differ, we are representing it with (X).
Global3.png



Step 4.
If the SQL Server Name field has anything different from the image in Step # 3, you will need to access the Server that is storing the databases. You may need to contact your IT department for assistance.



Step 5.
Navigating to the Backup files can be difficult inside SQL Server. We suggest creating a new folder to place all the database files in. Open Windows File Explorer by selecting the icon on your computer.
SQL15.png
File Explorer



Step 6.
Select the C: Drive - right click in the drive and select Add New - select Folder. Name the folder SQL Backup.
SQL16.png
SLQ51.png
SQL17.png
C: Drive New Folder SQL Backup



Step 7.
Select the Windows Start button - find the Microsoft SQL Server 2008 R2 (or your version up to SQL Server 2016) folder - select the folder to expand it.
If you are using SQL Server 2017 or above you will select the SQL Server Tools (your version) folder.
SQL18.png
SQL19.png
SQL22.png
Windows Start 2008 to 2016 Versions Versions above 2016



Step 8.
Find the SQL Server Management Studio icon - select it.
SQL20.png



Step 9.
On the Log In page enter the following for the Default VersaCall setup where SQL Express is being used - click on the Connect button. If you are accessing another server, please contact your IT department for the sign in information.
SQL21.png
Server Name - 127.0.0.1\SQLEXPRESS
Login - sa
Password - SQLServer123



Step 10.
Expand the Databases folder - all of the VersaCall databases available will show.
ResSQL2.png



Step 11.
Click on the Database you want to backup so that it is highlighted.
ResSQL3.png



Step 12.
Right click on the selected Database - select Tasks - select Backup.
ResSQL1.png



Step 13.
Under Source - Backup Component - ensure Database is selected. Under Destination - ensure Disk is selected. Click on the Add button.
ResSQL4.png



Step 14.
Select the "..." button on the Select Backup Destination window.
ResSQL5.png



Step 15.
If you created the SQL Backup folder explained in the previous steps - use the file tree to navigate to C:\SQL Backup - click on the folder so that it is highlighted. If you have a different folder that you want to use, navigate to its location.
ResSQL6.png



Step 16.
Go to the bottom of the window - ensure C:\SQL Backup is shown in the Selected Path field.
ResSQL7.png



Step 17.
Click in the File Name field - enter the name of the database to back up followed by ".bak". Select the OK button.
ResSQL8.png



Step 18.
On the Select Backup Destination window ensure the File Name field is correct - select the OK button.
ResSQL9.png



Step 19.
In the Back up to section click on the location selected in the steps above so that it is highlighted - click on the OK button.
ResSQL10.png



Step 20.
A successful message will appear on the screen - select OK button. If you receive an error message of any kind, contact VersaCall Support for assistance.
ResSQL11.png



Step 21.
Repeat the steps to backup any remaining databases. When all databases have been backed up, close all open windows.



RelatedHowTos.png
Select a Guide Here
Update VersaCall Databases using SQL Server
How to Script an SQL Database to an Earlier Version of SQL Server
Backup VersaCall Databases using VT3000 - Download Files
Backup VersaCall Databases using VT3000 - Make a Local Backup
Backup VersaCall Databases using VT3000 - Send the Backup to VersaCall
Update VersaCall Databases using VT3000
Restore VersaCall Databases using VT3000
How to Fix the "Database Connection Closed" Error



SearchHeader.png

 



VC Footer.png
Follow Us On LinkedIn View our Blog


Retrieved from "http://support.versacall.com/index.php?title=VT3000_-_Back_Up_Database_-_SQL_Server&oldid=9421"