Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
how to schedule backup job in sql server 2008 r2

Answered how to schedule backup job in sql server 2008 r2

  • Tuesday, June 12, 2012 3:43 AM
     
     
    Sign In to Vote
    0

    Hello all

    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,

    samiya

    samiya

     

All Replies

  • Tuesday, June 12, 2012 3:56 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Please check-out below MSDN url

    http://msdn.microsoft.com/en-us/library/ms189647.aspx

    Regards,
    Ahmed Ibrahim
    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
     
     
    Sign In to Vote
    0

    Hi Samiya,

    *You can create a maintanance plan for backup (In which you can get options for taking backup of all databases.)

    Or

    * 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

    http://www.petri.co.il/create-backup-job-in-sql-server.htm

    http://www.techbubbles.com/sql-server/creating-maintenance-plans-in-sql-server-2008-r2/

    http://msdn.microsoft.com/en-us/library/ms189953.aspx

    http://msdn.microsoft.com/en-us/library/ms177266%28v=sql.105%29.aspx


    • Edited by sushil naik Tuesday, June 12, 2012 4:30 AM
    •  
     
  • Tuesday, June 12, 2012 5:30 AM
     
     
    Sign In to Vote
    0
    As suggested, maintenance plans are common. Or use Ola's maint procedures at ola.hallengren.com.

    Tibor Karaszi, SQL Server MVP | web | blog

     
  • Tuesday, June 12, 2012 7:06 AM
     
     
    Sign In to Vote
    0
    Use 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