restoring SQL08R2Std to Express 08R2

[techseek]

Hello
I am not a DBA - just inherited sql and apps that run on top.
if the situation presented itself, would that be possible?
thx

 

[LyleU]

Techseek,

Yes.

We do this with selected clients Dynamics GP accounting databases whenever we have extensive reporting or cleanup work to do for them.


Lyle
----
"For every expert, there is an equal and opposite expert." - Arthur C. Clarke.

 

[Danster]

So long as the database falls within the size limits of SQL Express, you should be fine, as long as the SQL08R2Std hasn't been service packed to increase the version higher than Express. SQL will not restore to a lower version.

cheers

 

[techseek]

Thank you both for your information