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

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

Will I able to do the upgrade of SQL Server.

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I have resource database and all the system objects are stored into it..If I will delete it is there any problem will create, will I able to do the upgrade of SQL Server after deleting it.... Please answer if you have rigid knowledge..."SQLSERVER DBA" "INDIA"

View Complete Post

More Related Resource Links

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

COM Server upgrade breaks interface

Ok, so apparently I posted this question in the wrong group last time, so I'll try again :) ======= I have an ActiveX exe that I’m calling from a Web Service. The ActiveX exe however gets upgraded independently of the web service. When this happens the web service breaks. Looking in the registry, under HKEY_LOCAL_MACHING \ SOFTWARE \ Classes \ {DLL Name}  - the GUID seems to remain consistent after upgrading the EXE, however I’m guessing the interface GUIDs much change for some reason. Is there perhaps a GUID per interface that’s exposed that’s changing when the ActiveX EXE is recompiled? If so can someone tell me how to view these interfaces and confirm that his is or is not the case. ======= What I'm trying to figure out of why my Interop Proxy DLL stops working every time the developer of this ActiveX EXE releases a new version. As I said that GUID in the redistry seems to remain the same. I'm just not sure how to go about debugging the issue. I don't want to have to re-compile my application every time he releases a new version and he does not seem to think he's changing the interface - so something else must be changing when you /unregserver  /regserver the COM server \ ActiveX EXE. ========

HTTP Error 500.19 - Internal Server Error after SharePoint 2010 In-place upgrade

Hello We have done an SharePoint 2010 In-Place Upgrade. After the upgrade, we can access the Central Administration page without problems. However, when accessing the standard http port 80 site, the following error appears: Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.   <fieldset><legend>Detailed Error Information</legend> Module IIS Web Core Notification Unknown Handler Not yet determined Error Code 0x80070032 Config Error The configuration section 'system.web.extensions' cannot be read because it is missing a section declaration Config File \\?\C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config Requested URL http://coolsharepoint:80/ Physical Path   Logon Method Not yet determined Logon User Not yet determined </fieldset> <fieldset><legend>Config Source</legend> 534: </location> 535: <system.web.extensions> 536: <scripting> </fieldset>

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.

Health Analyzer reports "Product / patch installation or server upgrade required." and I can't seem

The text of the error is: On server SHAREPOINTSERVER, once all required products and/or patches are installed, perform an upgrade by either running PSConfigUI.exe or by executing the command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures". If a former upgrade attempt has failed, you may need to resolve upgrade specific issues before attempting upgrade again. Refer to the upgrade status page (http://sharepointserver:XXXX/_admin/UpgradeStatus.aspx) for information about current and prior upgrade attempts, and to determine issues that may be preventing upgrade from succeeding. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142700". So I went to the server in question and ran the command line quoted in the error message and then I get this error back: Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1 4\LOGS\PSCDiagnostics_....log and the application event log. So fine, I look into the event log and get this: Failed to initiate the upgrade sequence. An exception of type System.IO.IOException was thrown. Additional exception information: Access to the path 'C:\ProgramData\Microsoft\SharePoi

Product / Patch installation or server upgrade required in Health Reporting area

Via PSCDiag Log I get ERR Task upgrade has failed with an unknown exception ERR Exeception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action of Microsoft.SharePoint.Upgrade.SPIiswebsSitewssSequence Failed--->System.DirectoryServices.DirectoryServicesCOMException (0x80070003): The system cannot find the path specified.

Health Analyzer - Missing server side dependencies errors after doing in-place upgrade

I have a SharePoint 2010 application server & web server. After performing an in-place upgrade, I get the following errors in my Health Analyzer - Missing server side dependencies:   [MissingFeature] Database [Intranet_WSS_Content_Corporate_11000] has reference(s) to a missing feature: Id = [3fbd49d6-a25a-4f2f-89d6-1b0fd979435b]. The feature with Id 3fbd49d6-a25a-4f2f-89d6-1b0fd979435b is referenced in the database [Intranet_WSS_Content_Corporate_11000], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary. [MissingFeature] Database [Intranet_WSS_Content_Corporate_11000] has reference(s) to a missing feature: Id = [03ccceb8-6c39-4b02-870a-41ef6a93979d]. The feature with Id 03ccceb8-6c39-4b02-870a-41ef6a93979d is referenced in the database [Intranet_WSS_Content_Corporate_11000], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary. [MissingFeature] Database [Intranet_WSS_Content_Corporate_11000] has reference(s) to a missing feature: Id = [747755cd-d060-4663-961c-9b0cc43724e9]. The feature with Id 747755cd-d060-4663-961c-9b0cc43724e9 is referenced in the database [Intranet_WSS_Content_Corporate_11000], but is not insta

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

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

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  

Upgrade from MOSS 2007 Trial to Sharepoint Server 2010

I have a client who setup MOSS 2007 Trial and are coming up on the expiration.  Instead of buying a key for MOSS 2007 they purchased Sharepoint 2010.  I'm having some problems upgrading because its the trial.  What are my options for upgrading/migrating over to Sharepoitn 2010?

MOSS 2007 to SharePoint Server 2010 Hybrid Upgrade Approach on Windows Server 2003 x64

There's some guidance circulating about upgrading to 2010 with a mix of In-Place and Database Attach upgrade methods. My Central Admin and SharePoint Web App are on a 64 bit server, but it's running on Windows server 2003 x64 and not on Windows Server 2008 or 2008 R2. SharePoint Team Blog says Server 2008 or 2008 R2 is required for SP2010. If I want to do the hybrid upgrade approach, is it possible to first upgrade the OS to Server 2008 R2 on the server where my Central Admin and SP Web App runs?  Or will this break MOSS 2007?

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