.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

OK to uninstall microsoft sql server 2008 r2 upgrade advisor?

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :Sql Server
After upgrading to microsoft sql server 2008 r2, is it OK to uninstall microsoft sql server 2008 r2 upgrade advisor and microsoft  sql server 2008 r2 setup support files?

View Complete Post

More Related Resource Links

sql server 2000 to SQL Server 2008 in place upgrade -- Upgrade advisor help

Hello Every body Please advise me the steps i am following are correct I need to improve some more... I want upgrade from sql server 2000 to SQL Server 2008, Plese confirm the steps 1.Setup Test SQL Server 2000 similar to Production SQLServer 2000. 2.Setup other server with SQL Server 2008. 3.Install the Upgrade advisor in SQL Server 2008 system 4.Select the  Play back(under "sql server 2000 server") in Upgrade advisor tool  and fill the SQL Server2000 Server name and authontication. 5.Click on Capture play back(take the all the backups run some top 10 queries or application on top of SQL server 2000) 6.Please in shared drive(whcih can access by the SQL Server 2008 server) 7.Now click the "setup the test server" 8.Now click the upgrade test server 2008.. 9.camapre the trace files 10.View the Trace files differance. some body help me and plese confirm those steps are correct...I am in right direction..SNIVAS

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

Why upgrade is required from SQL Server 2000 to SQl Server 2008

Hi all Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"   This question was raised by my Boss why upgrade is required.   I stared saying   My: there is no more   support for SQL Server 2000 from Microsoft   Boss: what you will do  as DBA, Why Required Microsoft support   My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..   Boss: do you mean Database backup compression take full backup and compresse it using ZIP   Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?   Some body help me why really SQLServer 2008 is required and what are benefits   I have a link; please provide your greatest ideas so that I can convince my Boss.   http://www.mssqltips.com/tip.asp?tip=1462   share your greate Ideas please....   Thanks in Advance     SNIVAS

SQL Server 2008 Uninstall

I am running SQL Server 2008 on VISTA. I am having problems with SSIS components tha need to run in 32-bit.  It was recommended to unistall 2008 and re-install 2005.  However, trying to uninstall 2008 is causing my machine to freeze half-way through the process.  Before I tried to unistall I tried to repair and it also caused my screen to freeze (I issued a hard-shut down of my machine).  Now I am not sure what is happending.  How can I fix this?

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

Uninstall SQL Server 2008 trial version

I would like to know how to properly uninstall SQL Server 2008 trial version altogether.

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2 (Express)

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2?  The regular remove program does not have this option highlighted.    I am trying use some of the advance option and learn something more and now ssms is useless.         the discovery report tells me these are installed but I have no way of uninstalling.  .  I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version.  Please help.  I'd really appreciate it. " Sql Server 2008     Management Tools - Basic 1033 Express Edition 10.50.1092.20 No Sql Server 2008     Client Tools Connectivity 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools Backwards Compatibility 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools SDK 1033 Express Edition 10.1.2531.0 No "

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

upgrade to SQL server 2008 SP1 x64 IA

guys, I have upgraded my Databases from SQL Server 2000 SP4 to SQL Server 2008 SP1 x64 on Itanuim and used most common best practices but my queries was running on 2000 in shap now running very slow in SQL 2008 keeping in mind my current HW is very good and can't even comparing with 2000 server HW pls Advice , thanks in advance

Upgrade SQL Server 2000 to SQL Server 2008 in Cluster--Recomendations

Hi all I have   6 cluster environments and 10 standalone servers and mix  of  32 bit  64 bit. As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit. What I want to know is……… 1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition or I have purchase separately ? 2. How to do side by side upgrade in Cluster environment I mean I can’t ask my company to provide other cluster to do side by side upgrade. If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008. Thanks in Advance      SNIVAS

Error while trying to register DLLs for Microsoft Jet on Windows Server 2008 R2 64bit

Hello! I'm having issues with importing Excel spreadsheets into Microsoft SQL Server 2005 on a Windows Server 2008 R2 64bit server.  After browsing the web, it appears that the problem is with the DLL's used by Microsoft Jet.  I've thus attempted to re-register these DLL's.  However, I am receiving the following results. c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjetoledb40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjet40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjint40.dllThe module "msjint40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjter40.dllThe module "msjter40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjtes40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\mswstr10.dllThe module "mswstr10.dll" was loaded but the entry-point DLLRegisterServer was not found I've set the application pool for this site to use 32bit.  Please note that due to my role on the team, other options such as using ACE are not available to me, unless I can prove that I've exhausted all other options. Thoughts? Thanks,Mike

Problem with upgrade from SQL 2008 Express to SQL Server 2008 Enterprise

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

SQL Server 2008 performance: Decision to spend budget to upgrade to enterprise edition

Hi, Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party and we can’t change/modify database objects and they seem to be designed fine. The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition. I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations” and “Enhanced Read-ahead and Scan”: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx  How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”? Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with faster CPU and RAM? Thank you, Max

sql server 2008 version upgrade failed access to path is denied

upgrading from 2008 r2 eval to 2008 r2 enterprise. Use the maintenance option from setup. Get pretty far along in the process.  But then the following error. ( an additional note. setup warns that I am running sql server on a domain controller server. ) The link the error message points to has nothing to say. Why would my sql server upgrade fail? If I have to reinstall, will I lose my database data? thanks,   TITLE: Microsoft SQL Server 2008 R2 Setup ------------------------------ The following error has occurred: Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_ENT_1033.rtf' is denied. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400xBB814387  

SQL Server 2008 uninstall fails

While trying to remove SQL Server 2008 Express I get a message saying "SQL Server 2008 Setup has stopped working" Following is the log for the failure: Overall summary:   Final result:                  Failed: see details below   Exit code (Decimal):           -2068643839   Exit facility code:            1203   Exit error code:               1   Exit message:                  Failed: see details below   Start time:                    2010-09-11 15:03:47   End time:                      2010-09-11 15:05:23   Requested action:              Uninstall   Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100911_150303\sql_common_core_Cpu32_1.log   Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0   Machine Properties:  &nb

SQL Server 2008 Installation / Uninstall failed: Error 1603

Hello! I've been trying to install the SQL Server 2008 CTP 5.0 on a Windows Server 2008. The installation failed and left the shared components installed but the database engine was missing. So I tried to roll back the installation and stumbled upon the problem again. Now I can't install or uninstall any SQL Server (I tried 2005 as well) without these results. This is the file *Sql_Cpu32_1_ComponentUpdateSetup.log === Verbose logging started: 01.01.2001  20:30:03  Build type: SHIP UNICODE 4.00.6001.00  Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\setup100.exe ===MSI (c) (30:CC) [20:30:03:671]: Resetting cached policy valuesMSI (c) (30:CC) [20:30:03:671]: Machine policy value 'Debug' is 0MSI (c) (30:CC) [20:30:03:671]: ******* RunEngine:           ******* Product: {8151C56C-5426-481C-96AF-F221FE1A10F2}           ******* Action:            ******* CommandLine: **********MSI (c) (30:CC) [20:30:03:687]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (30:CC) [20:30:03:687]: Grabbed execution mutex.MSI (c) (30:CC) [20:30:04:062]: Cloaking enabled.MSI (c) (30:CC) [20:30:04:062]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (30:CC) [20:30:04:125]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (DC:28) [20:30:04:218]: Grabbed execution mutex.MSI (s) (

Cannot upgrade SQL Server 2008 R2 on Windows 2008 R2 64-bit to SP1

I am attempting to upgrade SQL Server 2008 R2 Enterprise edition (64-bit) to service pack 1.  The product version is 10.50.1600.1, which is, to the best of my knowledge, SQL Server 2008 R2, and also, again, to the best of my knowledge, an RTM version (when I run query SELECT SERVERPROPERT('productversion', SERVERPROPERTY('productlevel') in SSMS, the results display as "10.50.1600.1" and "RTM".  I downloaded SQLServer2008SP1-KB968369-x64-ENU.exe.  When I run this application, and get to the "Select Features" dialogue, no instance specific features are displayed (e.g. Database Engine, Analysis Server), Shared Features are displayed but cannot be selected, and when "Next" is clicked, the error "There are no SQL Server instances or shared features that can be updated on this computer". The OS on which I'm installing the service pack is Windows 2008 R2 Enterprise. What little I have gleaned from similar postings suggests that the installed version of SQL is not an RTM version.  How can that be, if, the only version I've ever installed on this new (virtual) server is reporting that it is, in fact, RTM? By the way, I've tried running "Repair" on the 3 installed named instances and the shared features, then reinstalling SP1, with no luck.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend