Tuesday, June 12, 2012 3:43 AM
I am new in a company as fresh in Junior DBA. My job is to take the backup of database daily. Following these steps: 1.right click on database(ex portal).
2. Navigate to task.
3. go to backup.
These steps I am doing them daily with wole databases seperately.
I need a way to take auto backup not manualy. I dont have any idya in this (job, schedule,management). or is this need any script?
Please help me in this issue step by step ...
Note : I am using sql server 2008 r2.
Thanks in advance,
Tuesday, June 12, 2012 3:56 AMModerator
Please check-out below MSDN url
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
Tuesday, June 12, 2012 4:20 AM
*You can create a maintanance plan for backup (In which you can get options for taking backup of all databases.)
* You can schedule a backup job using sql server agent using the script BACKUP DATABASE DB_NAME TO DISK ='X:\Location.bak'
please have a look on below articles
- Edited by sushil naik Tuesday, June 12, 2012 4:30 AM
Tuesday, June 12, 2012 5:30 AM
Tuesday, June 12, 2012 7:06 AMUse maintainess plan wizard through SSMS and it will guide you for rest of actions.
Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com