Difference between revisions of "VT3000 - Update Database - SQL Server"
Jump to navigation
Jump to search
SupportAdmin (talk | contribs) |
SupportAdmin (talk | contribs) m (Text replacement - "https://www.linkedin.com/company/versacall-technologies-inc-/mycompany/" to "https://www.linkedin.com/company/versacall/") |
||
(10 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
= | {|style="background:transparent; color:black" border="0" height="230" align="center" valign="bottom" | ||
|+style="background:transparent| | |||
|-align="center" | |||
| | |||
|[[Image:CallUsBtn.png|Call Now 858-677-6766]] | |||
| | |||
|[[Image:SubmitTckBtn.png|link=https://www.versacall.com/customer-support/service-ticket]] | |||
| | |||
|[[Image:EmailUsBtn.png|link=mailto:support@versacall.com?Subject=Help%20Needed%20Wiki&body=Type%20Message%20Here]] | |||
File: | |} | ||
<br> | |||
---- | |||
< | ---- | ||
<br> | |||
[[File:GeneralHeader.png]] | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
< | |- | ||
|<big>'''Overview'''</big> | |||
</ | {|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | ||
|valign="top" | | |||
|- | |||
|Use this method to update a VersaCall database using SQL Server. This may be needed if the update through the VT3000 Core software is not working properly or if you are storing the VersaCall databases on a separate computer/server. For this method to work properly, you must physically access the VersaCall computer or the Server that is storing the databases. The backup files must be on the VersaCall computer or the Server storing the databases. | |||
|} | |||
< | |} | ||
<br> | |||
</ | {|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | ||
|- | |||
|<big>'''Requirements'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
{| class="wikitable mw-collapsible mw-collapsed" width="775px;" | |||
= | |- | ||
|style="text-align: center;" | '''See Requirements Here''' | |||
1. | |- | ||
|'''1.''' The VT3000 Core Software installed and running on your system. | |||
|- | |||
|'''2.''' The Databases must already exist in your SQL Server Instance. | |||
|- | |||
|'''3.''' A backup file saved to the Computer/Server that the SQL Server Instance is running on. | |||
|- | |||
|'''4.''' 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. | |||
|- | |||
|'''5.''' SQL Server Instance name (IP Address/Computer Domain Name & SQL Server Instance Name). | |||
|- | |||
|'''6.''' SQL Server Instance login (Username & Password). | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
---- | |||
<br> | |||
[[File:InstructionHeader.png]] | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
< | |<big>'''Step 1.'''</big> | ||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Open the VT3000 web-interface - select VT3000 - select Administration - select System Settings - select Global. | |||
< | {|style="margin:left;" | ||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:3114_1.png|center|93px]] || [[File:Icon_systemsettings.png|center|93px]] || [[File:Icon_globalsettings.png|center|93px]] | |||
|- | |||
|style="text-align:center" | '''Administration''' || style="text-align:center" | '''System Settings''' || style="text-align:center" | '''Global''' | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
File: | ---- | ||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 2.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Under the Database Locations heading, expand the details for one of the databases. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
< | |[[File:Global2.png|center|316px]] | ||
|} | |||
< | |} | ||
|} | |||
|} | |||
<br> | |||
---- | |||
< | <br> | ||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 3.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|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). | |||
{|style="margin:left;" | |||
< | |valign="top" | | ||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:Global3.png|center|500px]] | |||
|} | |||
< | |} | ||
|} | |||
</ | |} | ||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 4.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|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. | |||
|} | |||
File: | |} | ||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 5.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
< | |- | ||
|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. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL15.png|center|100px]] | |||
< | |- | ||
|style="text-align:center" | '''File Explorer''' | |||
</ | |} | ||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
File: | <br> | ||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 6.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select the C: Drive - right click in the drive and select Add New - select Folder. Name the folder SQL Backup. After creating the folder, copy all of your databases into the folder. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL16.png|center|90px]] || [[File:SLQ51.png|center|413px]] || [[File:SQL17.png|center|100px]] | |||
|- | |||
|style="text-align:center" | '''C: Drive''' || style="text-align:center" | '''New Folder''' || style="text-align:center" | '''SQL Backup''' | |||
|} | |||
|} | |||
|} | |||
|} | |||
< | <br> | ||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 7.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|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. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center; width:775px;" | |||
|- | |||
|[[File:SQL18.png|center|border|100px]] || [[File:SQL19.png|border|center|268px]] || [[File:SQL22.png|border|center|221px]] | |||
|- | |||
|style="text-align:center" | '''Windows Start''' || style="text-align:center" | '''2008 to 2016 Versions''' || style="text-align:center" | '''Versions above 2016''' | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 8.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Find the SQL Server Management Studio icon - select it. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL20.png|center|256px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 9.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|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. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center; width:775px;" | |||
|- | |||
|[[File:SQL21.png|center|401px]] | |||
|} | |||
{|class="wikitable" style="background:white; align:center; width:775px;" | |||
|- | |||
|'''Server Name''' - 127.0.0.1\SQLEXPRESS | |||
|- | |||
|'''Login''' - sa | |||
|- | |||
|'''Password''' - SQLServer123 | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 10.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Click on the Databases folder so that it is highlighted - right click on the folder - select Restore Database. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL4.png|center|327px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 11.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Under Source select Device - select the "..." button on the right. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL5.png|center|629px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 12.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select the Add button. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL6.png|center|494px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 13.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Use the file tree to navigate to C:\SQL Backup - expand the folder. This is the folder we suggested making in the previous steps. If you setup something different please navigate to that location. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL7.png|center|213px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 14.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select a database file (double click on the file). | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL8.png|center|228px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 15.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Click on the OK button at the bottom of the window - all the file information will be generated in the fields. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL9.png|center|406px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 16.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Click on the OK button on the backup devices menu. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL10.png|center|494px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 17.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Restore database page will load. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center; width:775px;" | |||
|- | |||
|[[File:SLQ11.png|center|641px]] | |||
|} | |||
{|class="wikitable" style="background:white; align:center; width:775px;" | |||
|- | |||
|'''Source''' - shows the database file location that was selected. | |||
|- | |||
|'''Destination''' - ensure the correct Database is selected in the Database field. Our example shows we selected the Virtual Panels IV backup so we want to restore that to the existing Virtual Panels IV database. | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 18.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Under the Restore Plan heading ensure the Restore box is checked next to the file selected previously. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL12.png|center|634px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 19.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select Options under the Select page heading inside the Restore Database window. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL23.png|center|224px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 20.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Under the Restore Options heading click on the box for "Overwrite the existing database" option. Ensure the box is marked with a check mark. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL24.png|center|432px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 21.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Under the Server Connections heading click on the box for "Close existing connections to destination database" option. Ensure the box is marked with a check mark. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL25.png|center|330px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 22.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select OK button at the bottom of the window. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL13.png|center|287px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 23.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|A successfully restored window will appear, select the OK button. If you do not see a successful message appear or you get an error message, please contact VersaCall Support for assistance. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:SQL14.png|center|340px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 24.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Repeat the steps for each additional database that you need to Update/Restore. When you have completed the Update/Restore, close all open windows and launch the VT3000 software to check that all your data is correct. | |||
|} | |||
|} | |||
<br> | |||
---- | |||
---- | |||
<br> | |||
{|style="margin:auto;" | |||
|+ | |||
[[File:RelatedHowTos.png|center]] | |||
|align="center" | | |||
{| class="wikitable mw-collapsible mw-collapsed" width="400px;" | |||
|- | |||
|style="text-align: center;" | '''Select a Guide Here''' | |||
|- | |||
|[[VT3000 - Back Up Database - SQL Server|Backup 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]] | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:auto;" | |||
|+ | |||
[[File:SearchHeader.png|center]] | |||
|align="center" | | |||
{|class="wikitable" | |||
|- | |||
|<inputbox>type=search</inputbox> | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
[[File:VC Footer.png|center]] | |||
{|style="background:transparent; color:black" border="0" height="200" align="center" valign="bottom" cellpadding=10px cellspacing=10px | |||
|+style="background:transparent| | |||
|-align="center" | |||
| | |||
|[[File:LinkedIn.png|Follow Us On LinkedIn|link=https://www.linkedin.com/company/versacall/]] | |||
| | |||
|[[File:BlogIcon.png|View our Blog|link=https://www.versacall.com/blog/]] | |||
|} | |||
<br> | |||
[[Category:External Software]] | |||
[[Category:SQL Server]] | |||
[[Category:Database]] |
Latest revision as of 19:29, 20 April 2023
Overview
|
Requirements
|
Step 1.
|
Step 2.
|
Step 3.
|
Step 4.
|
Step 5.
|
Step 6.
|
Step 7.
|
Step 8.
|
Step 9.
|
Step 10.
|
Step 11.
|
Step 12.
|
Step 13.
|
Step 14.
|
Step 15.
|
Step 16.
|
Step 17.
|
Step 18.
|
Step 19.
|
Step 20.
|
Step 21.
|
Step 22.
|
Step 23.
|
Step 24.
|
|