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??!!
Clas Hortien replied
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.