MS SQL Server - Backing up an SQL Express Database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Backing up an SQL Express Database

Wayne Gibson

2005-06-29, 7:23 am

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

Keith Kratochvil

2005-06-29, 7:23 am

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$83
02bc10@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
>
>

Sponsored Links