View Complete Post
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
I already tried changing the logon account for SQL services and still receive the error.
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?
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 : 184.108.40.20635, Current License : Office SharePoint Server with Enterprise Client Access License
Database : SQL Server 2005 Express SP1 32-bit
I have tried to search for a definitive guide or steps on upgrading clustered SQL 2005 Standard to clustered SQL 2005 Enterprise, but have not found any.
Is there there any where that I have not looked?
Thanks in advance.
Can you tell me if this upgrade from Standard SQL 2008 to SQL Enterprise 2008 using simply the product key would also work if you have an existing A/P Standard 2008 Cluster. I wish to upgrade the hosts to Enterprise SQL 2008 to avail of Asyn Mirroring.
Current set-up: three node cluster running Windows Server 2003 Enterprise Edition SP2 with two instances of SQL Server 2005 Standard Edition SP2.
Virtual node 1: Standard Edition, default instance, Database Engine only
Virtual node 2: Standard Edition, named instance, Database Engine, Analysis Services and Integration Services
Physical node A: Prefered node for virtual node 1
Physical node B: Failover node for both virtual node 1 and 2 (thus having two installations of Standard Edition)
Physical node C: Prefered node for virtual node 2
We started off with this set-up because there was no need for Enterprise features, and SQL 2005 supports failover clustering with two nodes in Standard Edition. Saved a bundle of cash, so everybody's happy.ÃÂ Now we need to run a solution on virtual node 2 that requires Enterprise features in Analysis and Integration Services, so an edition upgrade is required on virtual node 2. I have done some research and found several edition upgrade examples, but none that match the above scenario. We are running production on these machines, so I can't risk experimenting with command line options, I have to be right the first time.
Is it possible to mix two editions of SQL Server 2005 in one cluster? Can I upgrade virtual node 2 to Enterprise but leave virtual node 1 at