Can I restore SQL Server Express 2005 to SQL Server 2005?

Hi, I have the following questions:
Can I make a full DB backup with SQL Server Express 2005 ?
that backup, can I restore it to another SQL Server Express 2005 ?
that same backup, can I restore it to SQL Server 2005 (not Express) ?
Can I generate a DB backup in some open format (like xml) with some T-SQL
command(s) ?
Thanks for your help
"byteman" <byteman@.discussions.microsoft.com> wrote in message
news:8C66303F-3A1F-416E-AC58-0A0A74CD56F4@.microsoft.com...
> Hi, I have the following questions:
> Can I make a full DB backup with SQL Server Express 2005 ?
>
Absolutely.
Same syntax as the big brothers.

> that backup, can I restore it to another SQL Server Express 2005 ?
>
Absolutely. Would be a pretty useless backup if you couldn't do that.

> that same backup, can I restore it to SQL Server 2005 (not Express) ?
>
Ayup. You can go the other way to if the backup is small enough.
Note however you may need to remap users to logins on the new machine.

> Can I generate a DB backup in some open format (like xml) with some T-SQL
> command(s) ?
No.
That's an interesting idea though.
You can BCP out individual tables using a query as XML. Script that and
you'd have your data, but not the schema.

> --
> Thanks for your help
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html