Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Full Backup

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

Former Member


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.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question