Professional Web Applications Themes

Backing up files - Microsoft SQL / MS SQL Server

Is it possible to create one job with transactional backups every 30 minutes using the NO FORMAT method but at the begining of the day use the WITH FORMAT method to earase everything in that file? If so, do you need code to test the time of the day? If thats true could someone help me develop the code I would need. I want to run a transactional backup at 7am WITH FORMAT and then one every 30 minutes til 7pm. Then at that time I will run a second job to do a full backup. That's why I need ...

  1. #1

    Default Backing up files

    Is it possible to create one job with transactional
    backups every 30 minutes using the NO FORMAT method but
    at the begining of the day use the WITH FORMAT method to
    earase everything in that file?

    If so, do you need code to test the time of the day? If
    thats true could someone help me develop the code I would
    need.

    I want to run a transactional backup at 7am WITH FORMAT
    and then one every 30 minutes til 7pm. Then at that time
    I will run a second job to do a full backup. That's why
    I need the file to be erased at the begining of the day
    for Job 1.

    Thanks!
    brian Guest

  2. #2

    Default Re: Backing up files

    Create one job + schedule for the FORMAT (I think you probably want INIT) and another job for the NO FORMAT (NO INIT) + schedule.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "brian" <com> wrote in message news:111001c36267$3d0d2110$gbl...
    Is it possible to create one job with transactional
    backups every 30 minutes using the NO FORMAT method but
    at the begining of the day use the WITH FORMAT method to
    earase everything in that file?

    If so, do you need code to test the time of the day? If
    thats true could someone help me develop the code I would
    need.

    I want to run a transactional backup at 7am WITH FORMAT
    and then one every 30 minutes til 7pm. Then at that time
    I will run a second job to do a full backup. That's why
    I need the file to be erased at the begining of the day
    for Job 1.

    Thanks!

    Tom Guest

  3. #3

    Default Re: Backing up files

    You could also do this in a single job ( if you wish) by using an if
    statement
    (I assume you run this every 30 minutes...

    if datepart(hh, getdate()) = 0 and datepart(mi,getdate()) < 30
    backup yada yada with init
    else
    backup yada yada with noini


    --
    Wayne Snyder, MCDBA, SQL Server MVP
    Computer Education Services Corporation (CESC), Charlotte, NC
    www.computeredservices.com
    (Please respond only to the newsgroups.)

    I support the Professional Association of SQL Server (PASS) and its
    community of SQL Server professionals.
    www.sqlpass.org


    "brian" <com> wrote in message
    news:111001c36267$3d0d2110$gbl... 


    Wayne Guest

Similar Threads

  1. Backing up NIS & NFS
    By Steve in forum Linux Setup, Configuration & Administration
    Replies: 4
    Last Post: January 5th, 11:22 PM
  2. Backing up data--HELP!
    By Kelledee in forum Windows XP/2000/ME
    Replies: 5
    Last Post: July 9th, 02:03 AM
  3. backing up to CD rom
    By pam in forum Windows XP/2000/ME
    Replies: 4
    Last Post: July 9th, 12:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139