Difference between revisions of "VT3000 - Back Up Database - SQL Server"
SupportAdmin (talk | contribs) |
SupportAdmin (talk | contribs) |
||
| Line 183: | Line 183: | ||
=Step by Step Guides= | ---- | ||
{|style="margin:auto;" | |||
|valign="top" | | |||
{| class="article-table mw-collapsible mw-collapsed" data-expandtext="▼" data-collapsetext="▲" | |||
!<span style="font-size:150%; color:#0645ad">Related - Step by Step Guides</span> | |||
|- | |||
|[[VT3000 - Update Database - SQL Server|Update VersaCall Databases using SQL Server]] | |||
|- | |||
|[[VT3000 - Scripting SQL Databases|How to Script an SQL Database to an Earlier Version of SQL Server]] | |||
|- | |||
|[[VT3000 - Back Up Database for Download - VT3000 Core|Backup VersaCall Databases using VT3000 - Download Files]] | |||
|- | |||
|[[VT3000 - Back Up Database Locally - VT3000 Core|Backup VersaCall Databases using VT3000 - Make a Local Backup]] | |||
|- | |||
|[[VT3000 - Send a Back Up of Databases - VT3000 Core|Backup VersaCall Databases using VT3000 - Send the Backup to VersaCall]] | |||
|- | |||
|[[VT3000 - Update Database - VT3000 Core|Update VersaCall Databases using VT3000]] | |||
|- | |||
|[[VT3000 - Restore Database - VT3000 Core|Restore VersaCall Databases using VT3000]] | |||
|- | |||
|[[VT3000 - Errors - Database Connection is Closed|How to Fix the "Database Connection Closed" Error]] | |||
|} | |||
|valign="top" | | |||
{| class="article-table mw-collapsible mw-collapsed" data-expandtext="▼" data-collapsetext="▲" | |||
!<span style="font-size:150%; color:#0645ad">Additional Help</span> | |||
|- | |||
|'''Submit a Ticket''' - https://www.versacall.com/customer-support/service-ticket | |||
|- | |||
|'''Training Videos''' - https://www.versacall.com/training | |||
|} | |||
|} | |||
---- | |||
{|style="margin:auto;" | |||
|align="center" | | |||
{|class="wikitable" | |||
!<span style="font-size:150%; color:#0645ad">Search</span> | |||
|- | |||
|<inputbox>type=search</inputbox> | |||
|} | |||
---- | |||
[[Category:External Software]] | [[Category:External Software]] | ||
[[Category:SQL Server]] | [[Category:SQL Server]] | ||
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 17:36, 31 August 2021
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
1. The VT3000 Core Software must be installed and running on your system.
2. The Databases must already exist on your SQL Server instance.
3. You must have the backup file saved on the computer/server that the SQL Server Instance is installed on.
4. You must have SQL Server Management Studio installed on the computer/server.
5. You must have the SQL Server name. This includes the computer name or IP Address and the SQL Server Instance name.
6. You must have the Login and Password for the SQL Server instance.
NOTE: If you have any questions regarding these requirements please contact VersaCall Support for assistance.
Instructions - Find the database(s) SQL Server location
1. Open the VT3000 web-interface - select VT3000 - select Administration - select System Settings, select Global.
Administration
2. Under the Database Locations heading, expand the details for one of the databases.
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).
4. If the SQL Server Name field has anything different from the image in # 3, you will need to access the Server that is storing the databases. You may need to contact your IT department for assistance.
Instructions - Backing Up the Database(s) SQL Server
The steps below show images from SQL Server 2008. The steps for other versions is the same and the screens will be very similar.
1. Navigating to the Backup files can be difficult inside SQL Server. We suggest creating a new folder. Open Windows File Explorer by selecting the icon.
2. Select the C Drive - right click on the icon and select New Folder.
3. Name the new Folder SQL Backup.
4. 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.
Windows Start
5. Find the SQL Server Management Studio icon - select it.
6. On the Log In page enter the following for the Default VersaCall Computer/System (Enter your Login & Password if different) - click on the Connect button. If you are accessing another server, please contact your IT department for the sign in information.
a. Server Name - 127.0.0.1\SQLEXPRESS
b. Login - sa
c. Password - SQLServer123
7. Expand the Databases folder - all of the VersaCall databases available will show.
8. Click on the Database you want to backup so that it is highlighted.
9. Right click on the selected Database - select Tasks - select Backup.
10. Under Source - Backup Component - ensure Database is selected. Under Destination - ensure Disk is selected. Click on the Add button.
11. Select the "..." button on the Select Backup Destination window.
12. Use the file tree to navigate to C:\SQL Backup - click on the folder so that it is highlighted.
13. Go to the bottom of the window - ensure C:\SQL Backup is shown in the Selected Path field.
14. Click in the File Name field - enter the name of the database to back up followed by ".bak". Select the OK button.
15. On the Select Backup Destination window ensure the File Name field is correct - select the OK button.
16. 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.
17. A successful message will appear on the screen - select OK button.
18. Repeat the steps above to backup any remaining databases.
|