Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sdrilling
Starting Member
1 Post |
 Posted - 2013-10-22 : 14:37:41
|
| We recently lost our server. As a result, we purchased a new server and decided to upgrade some of our software. We elected to install SQL 2012 BI edition to work with our CRM 2011. All of the installs went swimmingly along until we went to restore our SQL 2008 R2 databases. The resulting error stated the databases could not be restored with the error 'Org_MSCRM' cannot be started in this edition of SQL Server because it contains a partition function 'AuditPFN'. Only Enterprise edition of SQL Server supports partitioning. Database 'Org_MSCRM' cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 905)"The workaround for this error is to install an enterprise version (2008R2Enterprise) and run a script against the old database to a drop the Audit partition. After the script is generated and old database can then be loaded into the standard edition.Well ----- easier said than done because we do not own a copy of Enterprise. Our 2008 R2 software is standard and we are assuming the Tech (we outsourced the build of our original box) who built the original box put enterprise on it. So. After a very long discussion is there any other way to drop the audit partition on the old database? We have working and installed copies of 2008R2 Standard and 2012 BI. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-22 : 14:43:09
|
| I am not a lawyer, and the thought of being one gives me the creeps, so take this for what it is worth. And, consult your legal/compliance if this is allowed per the EULAs before you do this:Use an evaluation version of an enterprise edition, or use a developer edition (which is available for a very nominal cost) just to drop the partition. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-10-24 : 00:58:28
|
| Can try using developer edition to remove the partitions, then restore to your new copy. |
|
|
|
|
|
|
Downgrade DB from Enterprise to Standard