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 |
|
sqllover
Constraint Violating Yak Guru
338 Posts |
 Posted - 2013-10-16 : 10:32:12
|
| Hi,My production database has 2008 R2 enterprise edition and testing database server is 2008 R2 standard edition. Also my production database has some partition tables. I am trying to take the back up of my production database and restore it on the test environment standard version of database.Because of the partition table i am unable to restore it on the standard edition of sql database server.few constraints stops me doing that.i cannot drop the partition as the partitioned table's primary key is referenced in many tables. So is there any way to take the backup without partition and restore it on the another server? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-10-17 : 01:47:45
|
| are they in different filegroups?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Database Restore Issue