Server Change

ndonohoe
Member Posts: 15
What's the best way guys ??
I have a new virtual server Win 2012 Datacenter on 64bit with Intel Xeon E5-2665 @ 2.40GHz and 14.2 GB Ram. All setup with SQl Server 2008 R2. Database created with restore of previous backup and tested - all working well. - Dynamics Nav 2009 R2
I'm looking foreward to going live with this, but were uber busy here and I have little opportunity to take the live database offline. My plan was to...
1, take it offline and start a backup (full) - 20-25 mins
2, After completion, copy the backup file to the new server - it's a 90GB SQL backup file so 40-45 mins over network
3, Change the Server network settings IP and Name so the new one looks like the old one so clients would only have to reboot at most for shortcut to reach right database
4, Restore to new server - 25-35 mins
A long process that could take up to 2hrs !!
Recover Model is now simple and was toying with the idea of restoring a backup made on the day I'm switching, then restoring the differential or log file at the point of taking one offline and the new online.
Am I mad ? What is the fastest, safest proceedure ??
I have a new virtual server Win 2012 Datacenter on 64bit with Intel Xeon E5-2665 @ 2.40GHz and 14.2 GB Ram. All setup with SQl Server 2008 R2. Database created with restore of previous backup and tested - all working well. - Dynamics Nav 2009 R2
I'm looking foreward to going live with this, but were uber busy here and I have little opportunity to take the live database offline. My plan was to...
1, take it offline and start a backup (full) - 20-25 mins
2, After completion, copy the backup file to the new server - it's a 90GB SQL backup file so 40-45 mins over network
3, Change the Server network settings IP and Name so the new one looks like the old one so clients would only have to reboot at most for shortcut to reach right database
4, Restore to new server - 25-35 mins
A long process that could take up to 2hrs !!
Recover Model is now simple and was toying with the idea of restoring a backup made on the day I'm switching, then restoring the differential or log file at the point of taking one offline and the new online.
Am I mad ? What is the fastest, safest proceedure ??
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions