restore sql2005 SE Database to sql2005 EE

Question

Hai,

I have Need to restore My SQL2005 SE database to SQL2005 EE ..is this possible..? any one please help me.

Thanks

Senthil Kumar.N

Answer 1

Yes, it is possible as long as Restore actions is doing as  long as the destination instance to restore DB at it is the same as source one for versions/minor version number or less as follows:

• The first one( source )is 10.50.1600 and the other one (destination) is 10.50.2500 which in other words reflects SQL Server 2008 R2 and SQL Server 2008 R2 SP1 )

• Or the 1^st one is 10.0.1600 and the 2^nd one is 10.50.1600
• But it can't be from 10.50.1600  to 10.0.1600

Therefore, it doesn't concern any more restore from SD To ED or vice versa as long as they are stick to the above rules

Kindly let me know if any further help is needed

---

Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities

Answer 2

Therefore, it doesn't concern any more restore from SD To ED or vice versa as long as they are stick to the above rules

the above statement is not correct.

if you're using Enterprise Edition feature in the database than you can't restore it to a Standard Edition.

the most important EE features may be:

- table partitioning

- database compression (available since SQL 2008)

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 3

Hai,

Tried with detach and attach  method  and also tried to restore from SQL2005 SE .bkp file:-(

but getting error like version in-compatible ,could you please Tell me how to restore the DB... any other option please explain me.

Thanks

Senthil Kumar.N

Answer 4

hello Senthil,

please execute the following SQL statement on both SQL Server instance:

SELECT @@version

this will give a the exact version of the two SQL Server instance and we can tell you the reason for your problem

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 5

Hi senthikumar,

Comparing the version number of SQL Server Standard Edition instance and SQL Server Enterprise Edition instance, you could restore the database from a lower version instance to a higher version instance.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 6

yes u can restore, but verify which version of edition you rare using

if there is same version of SQL Server  with different edition not a problem

to check more about your SQL Server check my blog

http://sqlservr.blog.com/2012/07/06/how-to-know-the-server-details-of-your-server/

 

---

Ramesh Babu Vavilla MCTS,MSBI