<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Jonathan Kehayias
»
Use Backup/Restore to Minimize Upgrade...
22 posts, Page 1 of 3
1
2
3
»
»»
Use Backup/Restore to Minimize Upgrade Downtimes
Rate Topic
Display Mode
Topic Options
Author
Message
Jonathan Kehayias
Jonathan Kehayias
Posted Thursday, June 18, 2009 12:07 AM
SSCommitted
Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:26 PM
Points: 1,696,
Visits: 1,742
Comments posted to this topic are about the item
Use Backup/Restore to Minimize Upgrade Downtimes
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog
|
Twitter
|
MVP Profile
Training
|
Consulting
|
Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #737175
Pyay Nyein
Pyay Nyein
Posted Thursday, June 18, 2009 2:57 AM
SSC Journeyman
Group: General Forum Members
Last Login: Yesterday @ 3:49 AM
Points: 95,
Visits: 343
Thanks for the good article, Jonathan.
Post #737287
Jagadish Kumar Punnapu
Jagadish Kumar Punnapu
Posted Thursday, June 18, 2009 4:00 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 3:33 AM
Points: 122,
Visits: 99
I sincerely appreciate this idea Jonathan...
Post #737348
Amit W
Amit W
Posted Thursday, June 18, 2009 5:59 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:05 AM
Points: 772,
Visits: 105
Thanks for the article!
Just a thought...steps 1-7 can be done using setting up log shipping and the rest can be done using step 8 onwards when moving on to the new server.
Post #737435
publicbutler@imapmail.org
publicbutler@imapmail.org
Posted Thursday, June 18, 2009 5:59 AM
Valued Member
Group: General Forum Members
Last Login: Monday, February 11, 2013 7:28 AM
Points: 57,
Visits: 72
I have used this method for years. Even with busy and/or large databases, I can move a database server to a new piece of hardware with only about 10 minutes of downtime. I recently used the same method during migration of a number of legacy SQL 2000 boxes to SQL 2005.
- Jay
Post #737436
Noel McKinney
Noel McKinney
Posted Thursday, June 18, 2009 6:59 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007,
Visits: 767
Good article Jonathan, I've used these steps to move databases to new hardware and datacenter with just a few minutes of downtime. The key is making sure that the application(s) that use the databases are good to go. If possible you need to test such applications on the new hardware first to make sure the configurations are set properly... restore a backup of an actual database for such testing, using a "test" database might not reveal potential problems.
The other thing is to make sure that logins have been propagated to the new server.
Post #737492
alen teplitsky
alen teplitsky
Posted Thursday, June 18, 2009 7:30 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:15 PM
Points: 1,409,
Visits: 4,509
we're usually not as nice
if we do a side by side upgrade we tell people the cut off for R/O access. then we backup and restore on the new hardware. critical databases are on the SAN and we just point people to a replicated copy of the data while we upgrade the hardware
https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #737527
GRE (Gethyn Ellis)
GRE (Gethyn Ellis)
Posted Thursday, June 18, 2009 7:41 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:55 AM
Points: 1,024,
Visits: 2,768
Noel McKinney (6/18/2009)
Good article Jonathan, I've used these steps to move databases to new hardware and datacenter with just a few minutes of downtime. The key is making sure that the application(s) that use the databases are good to go. If possible you need to test such applications on the new hardware first to make sure the configurations are set properly... restore a backup of an actual database for such testing, using a "test" database might not reveal potential problems.
The other thing is to make sure that logins have been propagated to the new server.
The sp_help_revlogin stored proc could be useful for moving the logins.
edited to add URL:
http://support.microsoft.com/kb/246133
Gethyn Ellis
gethynellis.com
Post #737546
noeld
noeld
Posted Thursday, June 18, 2009 7:48 AM
SSCertifiable
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260,
Visits: 1,977
Ermm... Isn't this just a description of LogShipping ?
* Noel
Post #737554
GRE (Gethyn Ellis)
GRE (Gethyn Ellis)
Posted Thursday, June 18, 2009 8:00 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:55 AM
Points: 1,024,
Visits: 2,768
noeld (6/18/2009)
Ermm... Isn't this just a description of LogShipping ?
Yes it is, using a manual log shipping process to keep a large db up to date prior to the migration date. I used this many times and it does save alot time compared to 'doing it all the day'
Gethyn Ellis
gethynellis.com
Post #737565
« Prev Topic
|
Next Topic »
22 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
