InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:04:07 GMT20http://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxI am not sure if I can use the same plan. But, I am looking for upgrade plan that occured twice a year. Once in April and the other in October. I am looking for a template to have high level milestones and the same template will be used for future upgrade.... Please HELPThu, 21 Feb 2013 10:43:05 GMTKeithWalkerhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxVery useful information. Thanks.Sun, 10 May 2009 22:40:36 GMTAtif-ullah Sheikhhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxThanks Bill. Excellent list. Will be very handy when upgrading to 2008 version.Fri, 08 May 2009 14:16:33 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxThanks to everyone who read and commented on my article. I hope that it is useful for other DBAs who are developing an upgrade process. Also, after searching the internet, I did not find a database server upgrade template for SQL Server. My desire was to place a standard template on the internet for the SQL Server community to use in their upgrades.Bill RichardsFri, 08 May 2009 13:43:21 GMTBill Richards-377350http://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxVery detailed. I am going through a server consolidation this Sunday with some 70 databases and two machines. (We need a stressed icon.)Also we have web site monitoring, so that will have to be turned off so our phones aren't going nuts during the outage.Just want to add that I will have profiler running to proactively look for problems and fix them.Fri, 08 May 2009 11:41:17 GMTSailorhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxOutstanding article. This is an essential task that all DBAs do eventually have to do.Fri, 08 May 2009 09:43:35 GMTConan Whalen-McKain-370433http://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxExcellent Job, Bill!Fri, 08 May 2009 08:46:06 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxI can't agree more with all of the above, good article. I posted a reply to an how do I move to a cluster once, let me find it....Here is the answer I gave. It is relevant whether you are moving to newer, faster tin or a cluster.Moving Production Databases from a stand alone server to a cluster is not much different in moving dbs to a new stand alone server. (because you are upgrading the tin for instance). I've got a check list some where, let me dig it out...found it. This covers most (I can't guarantee all) things to think about.[b]Task_Name[/b][b]Cluster Config[/b]Check current Active-Active config okConvert to Active-PassiveTest Active-Passive Fail-overCluster AvailableInstall Oracle Driver for Linked Server (If required)Install JDBC Exteneded Stored Procs (If required)anything else specific to your site?Create mail profileInstall OutlookConfigure SQL mailSuccessful SQL Mail TestCluster Config Complete[b]Migration Prep[/b]Identify all Dependent DBs to migrateCheck for Original Server references in views, SPs etc.[list your db names here]Create script to update relevant objects found above, (if any)[b]DTS Packages[/b]Identify all packages to migrateManually "Save As" packages to NEW serverUpdate any affected pointers[b]Scheduled Jobs[/b]Identify all Jobs to be migratedCopy jobs to New ServerDO NOT COPY JOBS THAT RUN DTS PACKAGES. Reshedule packages insteadUpdate any affected pointers[b]Linked Servers[/b]Copy linked serversTest linked server[b]Security & Errs[/b]Copy Server Level loginsCopy DB LoginsTest accountsCopy User defined err messages (I always forget this)[b]New Backup Structure[/b]Create new backup structure on your backup server[b]Terminal Servers[/b]Identify all reg settings pointing to old server (If your app stores settings in the registary)Create reg update pointing to new server[b]New Server DBs Preperation[/b]Copy Migrating DBs to New Server (For test purposes)[list your db names here][b]Maintanence Plans[/b]Recreate System DBs backup planRecreate Sys DB optimisation planRecreate User DB backup plansRecreate User DB Integrity & optimisation plansTest plans via Scheduled JobCopy Old Server alerts - Check for Old Server references[b]Migration[/b]Terminal ServersApply reg update to all TS'sUpdate ODBC setting from OLD Server to to NewRun your app from ***EVERY*** TSDisbale old server Migrated Scheduled Jobs[b]Isolate Migrating DBs[/b][list your db names here] - place in Read-Only mode[b]Backup migrating DBs[/b][list your db names here][b]Restore Migrating DBs to New Server[/b][list your db names here]Check in FULL recovery modeRun any UPDATE scriptsEnable New Server Scheduled JobsUpdate any DTS connectionsPost Migration ChecksTerminal ServersRun your app .exe from EVERY TSIsolate dbs on old server, or better, turn it off.[b]Sunday Morning[/b]Check maintenance task completed successfullyCheck Scheduled Jobs completed successfullyCheck backups copied to SQLBackups shareMIGRATION COMPLETE - CLUSTER GO LIVEI'm sure this is not complete, but hopefully it is a good starter for 10 :)Any one else want to add to it?HTHDave JFri, 08 May 2009 07:26:58 GMTDavid Jacksonhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxGreat article Bill. As with most good articles you read it and say "Yeah, that makes sense", but then you realize how many times you leave out some of the steps.Fri, 08 May 2009 06:28:51 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxThanks for the good article! we are planning a server upgrade in the near future and it will become very handy :-DFri, 08 May 2009 03:12:12 GMTPyay Nyeinhttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxThanks Bill,For sharing such a good Upgrade plan Specially the Excel sheet you have uploaded.Fri, 08 May 2009 01:10:06 GMTshashi kanthttp://www.sqlservercentral.com/Forums/Topic712598-1218-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Database+Server+Upgrade/66427/">Database Server Upgrades – The Plan, The Template, and The Task List</A>[/B]Thu, 07 May 2009 22:05:46 GMTBill Richards-377350