Moving/Restoring The StarShip SQL Database
Rev A.T 20190220Moving/Restoring the StarShip SQL databaseThis document outlines the necessary steps to migrate the StarShip database from one Microsoft SQL Server 2012instance to another. The steps outlined assume that the StarShip Server and Microsoft SQL Server 2012 are alreadyinstalled on the new target machine to which the StarShip database will be migrated. If Microsoft SQL Server 2012 isalso being re-installed please follow the steps outlined in the complete StarShip Installation guide (MS SQL Serverinstallation section). Steps for SQL Server 2005 and 2008R2 are similar to below. If the StarShip Server is being reinstalled or moved to a new Server, see the StarShip Installation Guide or the Moving the StarShip Server document.Section A – Pre-Installation checklistSection B – Process OverviewSection C – Backup the StarShip databaseSection D – Restoring the StarShip databaseSection E – Pointing the StarShip Server Manager to the restored StarShip database on the new SQLServerSection A – Pre-Installation checklist Microsoft SQL Server 2012 Management Studio (if not already installed on the destination SQL machine)XP CMDSHELL enabled in the SQL Surface Area configuration on both SQL instances (source anddestination)Mixed Mode authentication enabledSysadmin „sa‟ user password or a SQL logon with „syadmin‟ rightsMS SQL 2012 (32-bit) Shared Management Objects and CLR Types installed on the StarShip Server machineMS SQL (Server OS version/bit) Native Client 2005 & 2012 installed on the StarShip Server machineEnsure all active StarShip shipments are posted and that all StarShip Client connections are closedSection B – Process OverviewSection C – Backup the StarShip database1.Create a FULL backup of the existing StarShip SQL database from Server Manager.a.b.2/20/2019If the StarShip database is lost, you do not have a backup of the StarShip database or you areunable to create a backup, you will need to create a new database from the StarShip ServerManager. (Database Create Update Wizard)If you already have a backup, proceed to Section DStarShip Server MigrationPage 1
2.Backup the StarShip database on the existing StarShip Server: Server Manager Database BackupWizard Manual backup (ensure that full backup is checked and make a note of the directory you arebacking up to)3.Ensure “Manual Backup” is selected, then click NEXT4.Click NEXT2/20/2019StarShip Server MigrationPage 2
5.Make a note of backup folder specified and ensure Full database backup is selected, then click NEXT2/20/2019StarShip Server MigrationPage 3
6.Click FINISH7.Locate the physical backup file specified in Step 5 above2/20/2019StarShip Server MigrationPage 4
8.Copy the physical backup file from the current location to a local directory on the new SQL Server boxSection D – Restoring the StarShip database9.On the new SQL Server box, open up MS SQL Management Studio and connect to the instance that will behosting the StarShip Database. Start All Programs Microsoft SQL Server 2005 SQL ServerManagement Studio Express10. Right click on the Database entry and select Restore database & filegroups2/20/2019StarShip Server MigrationPage 5
11. In the “To Database” field, enter StarShip12. Select the option “From device” and click the ellipsis ( )2/20/2019StarShip Server MigrationPage 6
13. Click ADD2/20/2019StarShip Server MigrationPage 7
14. Ensure that Files of type is set to “All Files”, navigate to the directory with the backup file then click OK15. Click OK2/20/2019StarShip Server MigrationPage 8
16. Ensure that the Restore flag is selected, then click OK17. Click OK to the confirmation message2/20/2019StarShip Server MigrationPage 9
Section E – Pointing the StarShip Server Manager to the restored StarShip database on the new SQLServer18. From the StarShip Server Manager, Stop the StarShip Core Service19. From the Database menu, select Connection Wizard2/20/2019StarShip Server MigrationPage 10
20. De-select “Use StarShip SQL admin ” Select “SQL Server Authentication”21. Enter the username and password for a SQL user with “sysadmin” rights. Then click NEXT22. Select the name of the restored database filename specified in Step 11. Then click NEXT2/20/2019StarShip Server MigrationPage 11
23. Click FINISH24. Select YES to run database updates25. Click OK26. Start the StarShip Core Service2/20/2019StarShip Server MigrationPage 12
27. Verify that the StarShip Server is pointing to the correct SQL instance2/20/2019StarShip Server MigrationPage 13
2/20/2019 StarShip Server Migration Page 1 Rev A.T 20190220 Moving/Restoring the StarShip SQL database This document outlines the necessary steps to migrate the StarShip database from one Microsoft SQL Server 2012 instance to another. The steps outlined assume that the StarShip Server a
May 02, 2018 · D. Program Evaluation ͟The organization has provided a description of the framework for how each program will be evaluated. The framework should include all the elements below: ͟The evaluation methods are cost-effective for the organization ͟Quantitative and qualitative data is being collected (at Basics tier, data collection must have begun)
Silat is a combative art of self-defense and survival rooted from Matay archipelago. It was traced at thé early of Langkasuka Kingdom (2nd century CE) till thé reign of Melaka (Malaysia) Sultanate era (13th century). Silat has now evolved to become part of social culture and tradition with thé appearance of a fine physical and spiritual .
On an exceptional basis, Member States may request UNESCO to provide thé candidates with access to thé platform so they can complète thé form by themselves. Thèse requests must be addressed to esd rize unesco. or by 15 A ril 2021 UNESCO will provide thé nomineewith accessto thé platform via their émail address.
̶The leading indicator of employee engagement is based on the quality of the relationship between employee and supervisor Empower your managers! ̶Help them understand the impact on the organization ̶Share important changes, plan options, tasks, and deadlines ̶Provide key messages and talking points ̶Prepare them to answer employee questions
Dr. Sunita Bharatwal** Dr. Pawan Garga*** Abstract Customer satisfaction is derived from thè functionalities and values, a product or Service can provide. The current study aims to segregate thè dimensions of ordine Service quality and gather insights on its impact on web shopping. The trends of purchases have
Chính Văn.- Còn đức Thế tôn thì tuệ giác cực kỳ trong sạch 8: hiện hành bất nhị 9, đạt đến vô tướng 10, đứng vào chỗ đứng của các đức Thế tôn 11, thể hiện tính bình đẳng của các Ngài, đến chỗ không còn chướng ngại 12, giáo pháp không thể khuynh đảo, tâm thức không bị cản trở, cái được
SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact- SQL). T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capab
hardware IP re-use and consistency accross product families and higher level programming language makes the development job far more convenient when dealing with the STM32 families. HIGH-PERFORMANCE HIGH DEGREE OF INTEGRATION AND RICH CONNECTIVITY STM32H7: highest performance STM32 MCUs with advanced features including DSP and FPU instructions based on Cortex -M7 with 1 to 2 Mbytes of .
