Move Database From Standard To Express

Our company uses MS SQL 2005 Standard for various databases. I've got the
Express Edition installed at home for doing work on the databases after hour
s.
Is it possible to copy/export the database from the Standard Edition to the
Express Edition and back?
What happens if the database is more than 4Gb?Hi
see the link bellow
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
it is not possible to do this.
What happens if the database is more than 4Gb
Server throws an error message saying that insufficient disk space or file
has reach its limit ,some thing like that.
in 2000 msde you can work around this by adding one more data file to the
file group. but i haven't tested this on sql express
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Hiwj" <Hiwj@.discussions.microsoft.com> wrote in message
news:7DDA6F6E-BC8F-4F61-8670-FAC5C830E63F@.microsoft.com...
> Our company uses MS SQL 2005 Standard for various databases. I've got the
> Express Edition installed at home for doing work on the databases after
> hours.
> Is it possible to copy/export the database from the Standard Edition to
> the
> Express Edition and back?
> What happens if the database is more than 4Gb?
>