September 1, 2010 at 3:04 pm
Hello folks,
I have an issue...We have a database in production server with filegroups.....I want to create a backup of the database on the production and restore it in the staging environment...but here is the problem.....
Our staging environment is in developer edition(SQL server) and so i cannot create the filegroups....How do i restore the production database in the staging environment??......any input is highly appreciated
Thanks & Regards
September 1, 2010 at 3:10 pm
There is no reason why Developer Edition would prevent you from creating filegroups.
September 1, 2010 at 3:49 pm
Please find the attachment for the screenshot(error message)....
September 1, 2010 at 3:49 pm
DEVELOPER EDITION = ENTERPRISE EDITION with a caveat that you cannot use Developer edition for production purpose.
You can create and restore them on Dev edtio too.
SQLBuddy
September 1, 2010 at 4:04 pm
Sorry...my bad, that's a Standard edition
September 1, 2010 at 9:09 pm
The error message explains it fairly well, and it has nothing to do with filegroups.
That feature is only supported by Enterprise Edition or Developer Edition.
September 1, 2010 at 9:55 pm
I know it is not supported....I need to figure out a way to restore the data from production to the development environment
September 1, 2010 at 10:55 pm
Since you have enterprise edition on the production server, my suggestion is to install same (=Developer) edition on staging and development servers too.
September 2, 2010 at 3:28 am
Sandy2704 (9/1/2010)
Please find the attachment for the screenshot(error message)....
TO me it seems to be a issue with table partitioning.... and this feature is only available with SQL Server EE.. http://www.microsoft.com/sqlserver/2005/en/us/enterprise-compare-editions.aspx
September 3, 2010 at 8:57 am
I agree on the Table Partitioning error!
September 6, 2010 at 2:23 pm
Yes standard and express edition doesn't support partitioning too, it's only possible in enterprise and developer edition
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply