Editing SME Server Move
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 25: | Line 25: | ||
# SSMS - right click tempdb in databases | # SSMS - right click tempdb in databases | ||
## in files set for both filetype rows and logs - intial size - autogrowth in MB, Initial size 512 MB | ## in files set for both filetype rows and logs - intial size - autogrowth in MB, Initial size 512 MB | ||
− | ## copy path of SQLBackup folder to right click top server in object explorer | + | ## copy path of SQLBackup folder to right click top server in object explorer, open facets, Backup directory |
− | + | select files radio button, choose backup in SWLBackup, | |
− | + | on files tab choose relocate all files to folder then data folder on top 2 options | |
+ | |||
# Rename Alias62.old | # Rename Alias62.old | ||
− | # SSMS Restore database from bakup, restore as path to CompanyNameData\CompanyNameData.mdf and CompanyNameData.LDF select files radio buttoms | + | # SSMS Restore database from bakup, restore as path to CompanyNameData\CompanyNameData.mdf and CompanyNameData.LDF |
+ | select files radio buttoms | ||
# Set up for initial company | # Set up for initial company | ||
## Server name is Local CompanyName-SME1\SQLEXPRESS | ## Server name is Local CompanyName-SME1\SQLEXPRESS | ||
Line 39: | Line 41: | ||
# make admin and users dbOwner | # make admin and users dbOwner | ||
# select CFPath From Defaults | # select CFPath From Defaults | ||
− | + | Update Defaults | |
− | + | Set CFPath - 'local path to CompanyNameData' | |
− | + | Update Defaults | |
+ | Set CFPath = 'Server path'19. Make 2 shortcuts, UNC & local | ||
+ | |||
# firewall.cpl - set ports inbound rules & outbound rules | # firewall.cpl - set ports inbound rules & outbound rules | ||
− | + | _MS SQL TCP - 1433 | |
− | + | _MS SQL UDP - 1439 | |
# take old server offline CompanyName62 | # take old server offline CompanyName62 | ||
− | + | See upgrade from 7.2-8.0 in docs and follow that | |
− | |||
******IF CLIENT MACHINES CANNOT CONNECT CHANGE THE SERVER NAME TO THE IP ADDRESS OF THE SERVER IN THE ALIAS AND ON THE DESKTOP SHORTCUTS****** | ******IF CLIENT MACHINES CANNOT CONNECT CHANGE THE SERVER NAME TO THE IP ADDRESS OF THE SERVER IN THE ALIAS AND ON THE DESKTOP SHORTCUTS****** | ||
DONT FORGET TO COPY ALL INFORMATION TO COMMON SERVICE-INSTALLATION INFO IN CUSTOMER INFORMATION IN SME | DONT FORGET TO COPY ALL INFORMATION TO COMMON SERVICE-INSTALLATION INFO IN CUSTOMER INFORMATION IN SME |