Full Backup

[Former Member]

Hi all,

I need help please .i want to back up all my database SQL server but im not sure which databae i have to back up in SSQL enterprise manager.

I have many DB :essjy,Mster,model msdb .....

which one i have to back up ,or should Right click on Database in SQL enterprise managre and view all then backup so that will do full backup for all databas??!!

Thank You

[clas_hortien · Accepted solution]

Hello,

you should backup every user database and the system databases master, msdb and model. You can either use the transaction DB13 for this or create a maintenance plan with the Enterprise Manager to backup all databases. You don't need to backup the tempdb, as it contains only temporarly data.

Regards

Clas