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 |
|
klm9971
Starting Member
2 Posts |
 Posted - 2010-03-24 : 10:17:35
|
Hello Forum Members,I am facing a strange error. Okay! I have two .mdf files, and one is successfully attached to MS SQL Server 2008. But, the other is not and giving me this error: TITLE: Microsoft SQL Server Management Studio------------------------------ Attach database failed for Server 'GATOR'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Database 'REAL_Warehouse_Sample_V6' cannot be started in this edition of SQL Server because it contains a partition function 'pf_Range_Fact'. Only Enterprise edition of SQL Server supports partitioning.Database 'REAL_Warehouse_Sample_V6' cannot be started because some of the database functionality is not available in the current edition of SQL Server.Converting database 'REAL_Warehouse_Sample_V6' from version 611 to the current version 655.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 611 to version 621.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 621 to version 622.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 622 to version 625.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 625 to version 626.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 626 to version 627.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 627 to version 628.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 628 to version 629.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 629 to version 630.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 630 to version 631.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 631 to version 632.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 632 to version 633.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 633 to version 634.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 634 to version 635.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 635 to version 636.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 636 to version 637.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 637 to version 638.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 638 to version 639.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 639 to version 640.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 640 to version 641.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 641 to version 642.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 642 to version 643.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 643 to version 644.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 644 to version 645.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 645 to version 646.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 646 to version 647.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 647 to version 648.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 648 to version 649.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 649 to version 650.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 650 to version 651.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 651 to version 652.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 652 to version 653.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 653 to version 654.Database 'REAL_Warehouse_Sample_V6' running the upgrade step from version 654 to version 655. (Microsoft SQL Server, Error: 905) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=905&LinkId=20476 ------------------------------BUTTONS: OK------------------------------Database 'REAL_Warehouse_Sample_V6' cannot be started in this edition of SQL Server because it contains a partition function 'pf_Range_Fact'. Only Enterprise edition of SQL Server supports partitioning.Should I have to use Enterprise Edition of SQL 2008 for this?Thank You all for your input  |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-03-24 : 11:07:31
|
| Partition function was introduced in SQL Server 2005.As far as i know, it is supported in SQL Server Enterprise edition and SQL Server developer edition only.You need to use one of the two to attach the mdf.Regards,Bohra |
 |
|
|
|
|
|
Cannot attach .mdf file due to partition function