Friday, March 9, 2012

Restore of SQL Personal Edition DB onto SQL Standard

Are there any issues with restoring a normal DB backup from a machine runnin
g
SQL Personal Edition onto a Standard Edition machine, and will the restored
DB have the scalability of any other Standard Edition DB?
Thanks,
Mike Bell.No issues. Scalability will not be affected. All editions use the same
on-disk file structures so the databases are interchangable.
Geoff N. Hiten
Microsoft SQL Server MVP
"mjhbell" <mjhbell@.discussions.microsoft.com> wrote in message
news:FD211F6E-98E5-4728-AB7D-EF0665316F5C@.microsoft.com...
> Are there any issues with restoring a normal DB backup from a machine
> running
> SQL Personal Edition onto a Standard Edition machine, and will the
> restored
> DB have the scalability of any other Standard Edition DB?
> Thanks,
> Mike Bell.|||The scalability is not built into the database itself. You will be fine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mjhbell" <mjhbell@.discussions.microsoft.com> wrote in message
news:FD211F6E-98E5-4728-AB7D-EF0665316F5C@.microsoft.com...
> Are there any issues with restoring a normal DB backup from a machine runn
ing
> SQL Personal Edition onto a Standard Edition machine, and will the restore
d
> DB have the scalability of any other Standard Edition DB?
> Thanks,
> Mike Bell.

No comments:

Post a Comment