Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Thursday 28 November 2019

migrate 32 bit to 64 bit sql server

Pre Implementation Steps

Script out logins
Script out Linked Servers
Script out jobs
Take system database(master,model,msdb) Full Backup
Take user database Full Backup

Steps

Install new VM with Windows Server with required RAM and partition 4 drives as system and data/log and backup and tempdb
add hostname as newserver
Copy application files from oldserver to newserver
Install SQL Server 2016 Enterprise edition 64 bit  with latest SP(Service Pack) as per existing collation(Required collation)
Create logins from oldserver which we scripted out earlier
Create Linked Servers from oldserver which we scripted out earlier
Test Linked server connections
Restore user database from oldserver which we backedup
Restore msdb database from oldserver which we backedup would create jobs and schedules
Check jobs whether running or not
Configure DB mail and check connectivity
Test applications connections and functionality

Post Implementation Steps


Install ODBC/OLEDB Drivers for excel to be worked for import/export
Configure SQL Server memory as per RAM size
Configure Error log files
Create tempdb secondary files as per no of cores/processors
Configure SQL Agent history
Implementation of 32 bit to 64 bit SQL Server instance
Take Backup on system and user databases on oldserver
Stop SQL Services on old server
copy backup file  to newserver local
Restore user databases on newserver
change the IP/hostname from newservername to oldservername
restart server machine
verify hostname
Change SQL Service instance name from newservername to oldservername
Restart SQL Service
Verify SQL Server name
Check application connectivity and functionality
Check Report working fine