Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
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