Backup SQL server express

[safeastinkywinky]

Is there a simple backup script to backup SQL Server 2005 Express as it doesn't have the SQL server agent like SQL Server 2005.

I just want to perform a full database backup of all my databases every week or so to run on a schedule (I know once I have the script I can use MS backup to execute the script as an sqlcmd).

 

[THT]

Dunno if 2005 has Osql?

If it does, thats the badboy you need

 

[pinkaardvark]

You can download a version of the management console for it. Also with express you can just copy the mdf and ldf files to a new location to back it up and then reattach then as necessary.

Or just use the most important tool in the box ie google

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx
http://www.sqldbatips.com/showarticle.asp?ID=27