Backing up an SQL Express Database

Hi,
Can someone tell how I create a backup of an SQL Express Database, so that I
can restore it into SQL Server 2005.
Many thanks
Wayne
You should be able to use T-SQL:
BACKUP DATABASE foo TO DISK = 'x:\foo.bak' WITH INIT
Keith
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9u24i$68b$1$8302bc10@.news.demon.co.uk...
> Hi,
> Can someone tell how I create a backup of an SQL Express Database, so that
> I can restore it into SQL Server 2005.
> Many thanks
> Wayne
>

Backing up an SQL Express Database

Hi,
Can someone tell how I create a backup of an SQL Express Database, so that I
can restore it into SQL Server 2005.
Many thanks
Wayne
You should be able to use T-SQL:
BACKUP DATABASE foo TO DISK = 'x:\foo.bak' WITH INIT
Keith
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9u24i$68b$1$8302bc10@.news.demon.co.uk...
> Hi,
> Can someone tell how I create a backup of an SQL Express Database, so that
> I can restore it into SQL Server 2005.
> Many thanks
> Wayne
>

Backing up an SQL Express Database

Hi,
Can someone tell how I create a backup of an SQL Express Database, so that I
can restore it into SQL Server 2005.
Many thanks
WayneYou should be able to use T-SQL:
BACKUP DATABASE foo TO DISK = 'x:\foo.bak' WITH INIT
Keith
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9u24i$68b$1$8302bc10@.news.demon.co.uk...
> Hi,
> Can someone tell how I create a backup of an SQL Express Database, so that
> I can restore it into SQL Server 2005.
> Many thanks
> Wayne
>