backup for SQL Server Express

Can someone tell me how to backup SQL server express 2005?
Joel
BACKUP DATABASE dbname TO DISK='C:\dbname.BAK'
"Joel" <nowhere@.nowhere.com> wrote in message
news:%23j4pEsg7GHA.4116@.TK2MSFTNGP03.phx.gbl...
> Can someone tell me how to backup SQL server express 2005?
>
|||This might be useful:
http://www.sqldbatips.com/showcode.asp?ID=26
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.sqldbatips.com/showarticle.asp?ID=29
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joel" <nowhere@.nowhere.com> wrote in message news:%23j4pEsg7GHA.4116@.TK2MSFTNGP03.phx.gbl...
> Can someone tell me how to backup SQL server express 2005?
>
|||And if you are using Management Studio Express, you
can use the backup dialog from object explorer or backup
templates. You can find details on these methods in the
following article:
http://www.microsoft.com/technet/pro...expwssmse.mspx
-Sue
On Thu, 12 Oct 2006 09:30:49 -0500, "Joel"
<nowhere@.nowhere.com> wrote:

>Can someone tell me how to backup SQL server express 2005?
>
|||I have created a DTS and job that controls all my SQLExpress backups
from a central location. I use xp_delete_file to dump old files.
Permissions needed to be set up for the account running the central
instance. (I imagine this could all be done with SSIS)
If you email me, I can send you some files.
Terry
Uri Dimant wrote:[vbcol=seagreen]
> Joel
> BACKUP DATABASE dbname TO DISK='C:\dbname.BAK'
>
>
> "Joel" <nowhere@.nowhere.com> wrote in message
> news:%23j4pEsg7GHA.4116@.TK2MSFTNGP03.phx.gbl...