Automated backup

  • Was unsure where to place this post.

    Windows Server 2003R2 w/ Sp2

    MS SQL 2005

    I currently use MS SQL 2005 to host my Citrix Datastore DB. I manually run a daily back up (Tasks>Backup).

    How difficult would this be to automated? I saw a post from another user that this can be accomplished using a script? I have googled this without luck.

    Any insight appreciated.

    Thanks,

    Kerry

  • you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005

  • jiqubal (1/28/2008)


    you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005

    Can you elaborate?

    I already know how to manually run a backup. I just need to know the details on how to automate that process.

  • Open 'Management' in Management Studio, select 'Maintenance Plans' and create a new maintenance plan using Maintenance Plan Wizard.

  • Using Maintenance Plan Wizard, you can automate the backup maintenance.

  • Thanks for the help! The Maintenance Plan (Wizard) worked great. Scheduled backups are running fine.

    Kerry

  • Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.

  • Steve Jones - Editor (1/30/2008)


    Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.

    Do I restore the Trans Log in the same manner I restored the DB's?

    How do I restore the MASTER DB? From a command line I ran sqlservr.exe -f, but I don't know how to restore MASTER DB from command line?

    Should I bve restoring items in a particular manner?

    Appreciate the help!

    Kerry

  • There are special procedures to follow if you need to restore system databases.

    You will want to read up on there from Books Online. Link is

    http://msdn2.microsoft.com/en-us/library/ms190190.aspx

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Ok, update.

    I performed the following:

    1. Formatted the drive, installed OS, installed SQL 2005

    2. Restored my specific DB

    - NOTE: Did NOT restore the MASTER DB

    3. Added user account under logins

    All seems to be working.

    Again, keep in mind this is a very small DB with on a single user. Am I missing something? Is there a method to automating the user account?

    Kerry

  • Steve Jones - Editor (1/30/2008)


    Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.

    Do I schedule the Tranaction Log backup to run at the same time as the DB backup?

    When restoring do I simply restore after I have restored the DB?

    Thanks,

    Kerry

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply