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


Top 5 Contributors of the Month
Abhijit
Post New Web Links

Best upgrade path 2005 exp to 2008 standard, different boxes

Posted By:      Posted Date: November 01, 2010    Points: 0   Category :Sql Server
 

What would you recommend as the best way to convert our databases from SQL 2005 Express to SQL Standard which are both up and running on different servers?  I'd prefer to leave the old server as-is so we can transfer one or two databases per weekend and leave the others as-is.  Would a backup and restore work when switching version, as in method one in this article?: http://support.microsoft.com/kb/314546

Or would there be a better way, such as using an import?




View Complete Post


More Related Resource Links

2005 Enterprise upgrade to 2008 Standard?

  
We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise

  

We moved our databases to new hardware today (using copy database wizard)

 

The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

Upgrade SQL Server 2005 Express 32-bit SP1 to SQL Server 2008 Standard on a 64-bit Server for use wi

  

When installing & configuring MOSS 2007 the default settings were choosen. So now when we try to access the SSMS I get a message "The evaluation period has expired. Please buy the product at the following url.". I do have a product key for SQL Server 2008 standard but when I am trying to perform a edition upgrade it doesn't detect the SQL Server Instance "OFFICESERVERS" so I am unable to upgrade the server. Because of the limitation in size we are unable to create new doc libraries or pages on the SP site.

Here are the details of the environment:

OS : Windows Server 2008 Standard SP1 64-bit

MOSS 2007 version : 12.0.0.6535, Current License : Office SharePoint Server with Enterprise Client Access License

Database : SQL Server 2005 Express SP1 32-bit


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.

SQL 2008 Upgrade Standard to Enterprise: Fail

  
I'm trying to upgrade an existing SQL Server 2008 SP1 Standard Edition to Enterprise.  Running the enterprise edition maintenance->Upgrade Edition wizard first got me the dreaded "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Eventually, I found an entry on Connect that mentioned closing all other windows and ensuring that the installer has the focus and this got me past that error.  Now that I can run the edition upgrade through to successful completion, it's not actually doing anything. Edition still reports as "Standard" and enterprise features such as "Compress Backups" do not work. I've run the upgrade twice and restarted the system to no effect. Before I do a "Rip and Replace" does anyone have any ideas on how to actually get the edition upgrade to work? Steve G. OS:    Windows Server 2008 R2 DB:    Product: SQL Server Standard Edition (64-bit)   Version: 10.0.2531.0 P.S. Just in case someone asks, yes, I did follow the instructions located here.

Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS

  
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in

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 SQL 2005 standard Runtime edition to SQL 2005 standard edition full version

  
We have a MS SQL 2005 standard edition runtime license. The SQL Server Runtime license is a license that lets an independent software vendor (ISV) embed the complete SQL Server code into a solution for use only by the ISV application. The customers of the ISV cannot use this SQL Server product to run other applications or to develop new applications, databases, or tables. Now we want to add a new database to the SQL. We know that we have to buy a full version of SQL 2008 standard edition. But the question is: How can we add a new database to the existing SQL. Do we have to uninstall SQL runtime license and install the full version and migrate the existing databse or can we change the key and add new databases to the SQL server?

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1

  
Name: Microsoft SQL Server 2005 Tools Hello, I am having a problem when trying to add the Client Components to an existing installation of SQL 2005 Standard Edition SP1 running on Windows 2003 Standard. The server was originally built with SQL 2005 Standard Edition and had SP1 installed at a later date. I am using the CD that SQL was originally installed with which is not a service packed copy of SQL. The reason given when clicking the details button is as follows: Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Any help would be greatly appreciated. Regards Steve

upgrade sql 2005 to 2008 issue

  
i am trying to upgrade sql server 2005 Enterprise edition sp2 to Sql server 2008 R2 Data center Edition on a windows 2003 Enterprise edition SP2. Up gradation fails to give 'FeatureUpgradeMatrixCheck' error. any ideas ? i don't find much online. I would like to upgrade ::: [Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)     Enterprise Edition on Windows NT 5.2  ] to [Microsoft SQL Server 2008 R2 (RTM)   Data Center Edition ] possible ? thx, jason

SSRS in place upgrade from 2005 to 2008 issue

  

I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

I have a SQL 2005 to 2008 upgrade that is failing

  

I have a SQL 2005 to 2008 upgrade that is failing.
I have tried:
- Reinstalling
- Repairing
- Slipstreaming SP1 in with install and repairing

I cannot find any good ideas on the web.  Any ideas would be appreciated. 

 

TITLE: Microsoft SQL Server 2008 Setup
------------------------------

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254024

------------------------------
BUTTONS:

OK
------------------------------

These services failed
Running post-windows installer configuration timing actions
Database engine services
SQL Server Replication
Full-Txt Search

 

Here is the LOG file for the Upgrade:
Overall summary:
  Final result:                

SSRS 2005 to 2008 upgrade: exporting to .PDF does not produce the same result

  

We have recently converted .rdl SSRS 2005 files to SSRS 2008 .rdl files. We do not have SSRS 2008 R2, we are working with the  first release. We are seeing issues when exporing a report to .pdf format:

1) when rendered in HTML, the function that displays page numbers (ie:page 1 of 2) for the report are correct. The standard function "Globals!TotalPages" is used to get the count of pages. We previewed a report in html in reports manager that had 1777 pages. when the report is exported to .pdf the last page displays page 1777 of 1816, even though there is no more pages beyond 1777.

2)When rendering the report in html a value is shown as "Caretaker1" but when exporting to adobe .pdf version 9.3, the same value is shown as "Caretaker2".

3)   One of our issues is

upgrade from SQl 2005 to SQl 2008

  

Hi there,

can i upgrade from sql 2005 to sql 2008 without any problems concerning database and replication, or should i remove sql 2005 and install fresh copy of sql 2008

Any recommandations?


Upgrade SqlDatabase 2005 to SqlDatabase 2008 Error

  

i have sql database 2005 and the log file when i want to update My sql server to 2008 i found the problem with attach the old datebase file the error is :

Msg 3415, Level 16, State 3, Line 1
Database 'SMMS_test' cannot be upgraded because it is read-only or has read-only files. Make the database
 or files writeable, and rerun recovery. Msg 1813, Level 16, State 2, Line 1 Could not open new database 'SMMS_test'. CREATE DATABASE is aborted.

plz help me to solve this problem and i want to attach my old 2005 databases thank all pro

the code i used is :

USE [master]
GO
CREATE DATABASE [SMMS_test] ON 
( FILENAME = N'D:\Databases\SMMS_test.mdf' ),
( FILENAME = N'D:\Databases\SMMS_test_log.ldf' )
 FOR ATTACH
GO
i use windows vista and sql server 2008 enterprise my instance is windows\Authentication mode I'm admin and it is my local PC

any one can help me ??????????


Categories: 
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