Database Backup

[ay2k_99]

Dear all,

if i m having the instance liek ABC and there are 50 database are running. i would like to backup all the database at one time from T-SQL statement how can i backup all the database at one time. for that i have to write script or is there any thing else other....

thanks,
Amey

[rmiao]

Have to write script, get db name from sysdatabases table with cursor.

[skhanal]

You can use database maintenance plan, the databases are backed up sequentially. It can also delete old backups.