InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 19:54:05 GMT20http://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxYou missed an upgrade method particularly applicable to 2000 to 2008 (R2) conversions:Machine swap.You have Server, with SQL2000/5.You buy/scrounge/spin up a VM NewServer.You install SQL2008(R2) on NewServer.You write down the IP's of each, then swap their IP's, swap the names, rejoin the domain if applicable, and change the SQL Server name.Wait N days, then get rid of Server (old).Fri, 20 May 2011 18:45:16 GMTNadrekhttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspx:w00t::hehe:Nice article. One question though, I upgraded from 2000 to 2005 and now we are ready for 2008. In the 2000 to 2005 I did rebuild the indexes after the upgrade was completed. Do you recommend to do the same from 2005 to 2008?:w00t::hehe:Fri, 20 May 2011 10:32:35 GMTFernando-235287http://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxGood job Arshad. Really liked the article. Keep up the good work.Fri, 20 May 2011 06:19:08 GMTSachin Samuel-286731http://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxHi...I have a SQL Server Cluster with 2 nodes configuration in Active / Active mode.What is the current procedure to made the upgrade process???I have Default instance in node A and de named Instance in the node B.I want to upgrade only named instance, i have to failover named instance from node B to node A and run the setup on node B?Mon, 16 May 2011 17:48:36 GMTtomas.nelsonhttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxVery good article. I have a few questions after reading your article where I'm not clear on for my "Side by Side Upgrade." I'm going to perform the following "check list" of steps from a SQL 2000 SP4 to SQL 2008 in a side by side upgrade:1. Install SQL 2008 on my new server.2. Run the SSUA on the new server to find all the issues with the databases on the SQL 2000 server.3. Clean up any issues reported by the SSUA.4. Ensure database consistency by running DBCC CHECKDB on all the system and user databases on the SQL 2000 server.5. Backup the SQL 2000 databases including the system databases.6. Restore all the databases including the system databases on the SQL 2008 server. Question: System databases first then user databases?Now this is where a big question came to mind when I was reading your "During upgrade" section. This section seems to imply that we are running Setup.exe from the DVD. Is this for an "In-place Upgrade? I got confused reading this section as it relates to my "Side by Side Upgrade" approach. As it is written it seems to imply that I installing SQL 2008 at this point.7. Revisit SSUA recommendations8. Update statistices9. Run DBCC UPDATEUSAGE on all databases, including system databases.I'm sure I'll find a few "fun" items along the way. Thank you in advance for answering my questions, and helping me get it all clear.Tue, 30 Mar 2010 14:20:25 GMTtstapenhorsthttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxYou need to script out jobs/logins and run the script on the SQL Server 2008. I think simply detach and attach of these system databases (master/msdb) will not work becuase of some internal table/sp name changes between versions.Sat, 06 Mar 2010 09:54:40 GMTArshad Ali-556241http://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspx[quote][b]gaurav.bhagat (3/6/2010)[/b][hr]I faced a similar issue but it was because the dba's had turned off dbo schema access in 2008 for developers.[/quote]Seems sqlservercentral forums need database tuning. I was trying to edit my above post to link it to 2000-2008 conversion post but I kept getting the default error page from the forums application -- looks like timeouts. Hopefully this one posts!!!Sat, 06 Mar 2010 05:42:02 GMTgaurav.bhagathttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxI faced a similar issue but it was because the dba's had turned off dbo schema access in 2008 for developers.Sat, 06 Mar 2010 05:31:26 GMTgaurav.bhagathttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxI have a question about the upgrade from 2005 to 2008... should you script all of your logins from master and script all the jobs and SSIS packages from MSDB and apply to the new 2008 (side by side update) or can you detach and attach your current Master and MSDB from 2005 to 2008?Thanks...Wed, 03 Jun 2009 23:55:36 GMTjseamourhttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxWe are doing a test run on updating SQL 2005 Standard Edition to SQL 2008 Standard Edition.We are doing this on a fresh install of the server and SQL 2005 and in the process, we renamed the computer after 2005 was installed. We did run the sp_dropserver and sp_addserver sprocs with the old name and new names and restarted our default instance.We have made it to the step entitled Reporting Services Authentication. We only have a default instance of 2005 installed. The text box labeled "Instance of SQL Server that hosts the report server database" is not editable and looks like it should contain the machine name, however it contains the old server name. Is there a chance that this value is coming from the RSReportServer.config file. Does anyone know of a way to check the contents of this file and of the best way to change the contents to reflect the new machine name?Thanks.Wed, 29 Apr 2009 16:29:06 GMTscot bickellhttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxHas anyone else problems with DB copy wizard? Source is MSSQL 2000, method is SQL Management objects. I need to keep the source DBs online, so detach-attach is out of question.Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 13:44:08 Progress: 2009-03-27 13:44:09.16 Source: mssql03_PKSQL2008_Transfer Objects Task Task just started the execution.: 0% complete End Progress Error: 2009-03-27 13:44:35.81 Code: 0x00000000 Source: mssql03_PKSQL2008_Transfer Objects Task Description: ERROR : errorCode=-1073548784 description=Executing the query "CREATE VIEW [dbo].[PoctyOS] AS SELECT dbo.Se..." failed with the following error: "Invalid object name 'dbo.Servers'.".This happens for any database I've tried - always it reports some "invalid object name" or "invalid column name" and of course the "invalid" object is there.Fri, 27 Mar 2009 07:26:34 GMTstep_czhttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxThanks.In a perfect world should'nt the compatibility level also change?Mon, 02 Mar 2009 04:10:35 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxIn my experiment from [i][b]Microsoft SQL Server 2005 - 9.00.3042.00[/b][/i] to [i][b]Microsoft SQL Server 2008 (RTM) - 10.0.1600.22[/b][/i] upgrade of user database using backup/restore and attach/detach, it didn't change the compatibility level. Here are few lines from MSDN:[b]Database Compatibility Level After Upgrade[/b]The compatibility levels of the tempdb, model, msdb and Resource databases are set to 100 after upgrade. The master system database retains the compatibility level it had before upgrade, unless that level was less than 80. If the compatibility level of master was less than 80 before upgrade, it is set to 80 after upgrade.If the compatibility level of a user database was 80 or 90 before upgrade, it remains the same after upgrade. If the compatibility level was 70 or less before upgrade, in the upgraded database, the compatibility level is set to 80, which is the lowest supported compatibility level in SQL Server 2008.More details can be found here:[size="7"][url=http://msdn.microsoft.com/en-us/library/bb933942.aspx]http://msdn.microsoft.com/en-us/library/bb933942.aspx[/url][/size]Mon, 02 Mar 2009 02:39:58 GMTArshad Ali-556241http://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxNice article.After a doing side by side upgrade the databases are moved to the new instance by dettach/attach or backup/restore. Will this change the compatibility level of the database being moved to sql 2008 instance.Mon, 02 Mar 2009 00:21:51 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic666218-1463-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Upgrade/65872/">Upgrade Strategies for SQL Server 2008</A>[/B]Sat, 28 Feb 2009 19:37:53 GMTArshad Ali-556241