restore sql server 2000 SE to sql server 2000 PE

Hi All,
Can i restore a database backup file from a SQL Server
2000 Standard Edition on a laptop with SQL Server Personal
Edition with an XP operating system?
Thank you,
-MitraAs long as it doesn't break the file size limit on Personal edition you
should be ok.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"mitra fatolahi" <mitra928@.hotmail.com> wrote in message
news:2f1c01c373d2$721dd530$a601280a@.phx.gbl...
Hi All,
Can i restore a database backup file from a SQL Server
2000 Standard Edition on a laptop with SQL Server Personal
Edition with an XP operating system?
Thank you,
-Mitra

Restore of SQL Personal Edition DB onto SQL Standard

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.
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 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.

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.

Restore of SQL Personal Edition DB onto SQL Standard

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.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 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.