Re: SQL 7.0 T-SQL Backup - Simple

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Justin Rich (jrich523_at_yahoo.spam)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 09:34:45 -0500

I was thinking i need a week worth of diff files so that wouldnt work but
then i realized that i back them up to tape so this should work out great,
now i just need to get the tapes and sql backup times correct :)

thanks for all your help, greatly appreciated.

Justin

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:OEU5RL52EHA.3128@TK2MSFTNGP14.phx.gbl...
> If you are already doing a diff and it suites your needs then just change
> the WITH NOINIT option on the diff backup to WITH INIT and it will
> overwrite the file each time.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Justin Rich" <jrich523@yahoo.spam> wrote in message
> news:e2sJlwz2EHA.3128@TK2MSFTNGP14.phx.gbl...
>> Simple is what I need but I don't really understand how to do two
>> different tasks in one job (you said full and diff in one job)
>> Really I just need a simple way to take care of my backups. It takes to
>> long to do a full backup every night so I need a diff or inc. Diff at
>> this point is quick enough so that's what I planned to do. And since I do
>> a full once a week I don't care about the old diffs after that point
>> (obviously) but it seems to just keep adding the diffs to that one backup
>> file.
>> whats the best way to go about doing a full backup Sunday night and a
>> diff the rest of the nights.
>> Im not as good at this as I should be so if you could give me some
>> details as to the steps I will have to take to get this accomplished I
>> would greatly appreciate it.
>>
>> Thanks
>> Justin
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>> news:OBn64Gb2EHA.2108@TK2MSFTNGP10.phx.gbl...
>>> YOur Full backup job should include another job step (or second command)
>>> that issues a DIFF backup with the INIT immediately after the FULL
>>> backup. That will clear out the backup Device for the diff's once a
>>> week. But if you are really looking for a "Simple" backup then you
>>> should use INIT with each DIFF call since a differential backup is
>>> always from the last FULL backup. So if you do a Diff every x hours
>>> there really is little need for the previous diff files. Unless they get
>>> corrupted or a special circumstance you will always restore the latest
>>> diff and not use the others.
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>>
>>>
>>> "Justin Rich" <jrich523@yahoo.spam> wrote in message
>>> news:%23roKVAV2EHA.3376@TK2MSFTNGP12.phx.gbl...
>>>> Sorry wasn't able to find the correct info for this question.
>>>>
>>>> I have a couple of databases I would like to backup to a network share.
>>>>
>>>> After reading some books it seemed like an easy process. create a Full
>>>> and a Diff backup and send it in the right direction. apparently this
>>>> isn't correct.
>>>>
>>>>
>>>> Diff job: sun - fri
>>>> BACKUP DATABASE [JDE_Prod] TO DISK =
>>>> N'\\usnh003qt01\jdebackup$\JDE_Prod\DIFF_jde_prod.bak' WITH NOINIT ,
>>>> NOUNLOAD , DIFFERENTIAL , NAME = N'DIFF_JDE_Prod', NOSKIP , STATS =
>>>> 10, NOFORMAT
>>>>
>>>> Full job: sat
>>>> BACKUP DATABASE [JDE_Prod] TO DISK =
>>>> N'\\usnh003qt01\jdebackup$\JDE_Prod\FULL_Prod.bak' WITH INIT ,
>>>> NOUNLOAD , NAME = N'FULL_JDE_Prod', NOSKIP , STATS = 10, NOFORMAT
>>>>
>>>> now, there is nothing that says "look to Full job" so the diff backup
>>>> is just growing and growing.. out of control..
>>>>
>>>> I saw something about the INIT and NOINIT but im not so sure that works
>>>> with the file backup.
>>>>
>>>> Can someone give me a little guidance as to how this should be done?
>>>>
>>>> Sorry for the basic question, I thought I would be able to find this
>>>> online but I haven't had much luck.
>>>>
>>>> thanks
>>>> Justin
>>>>
>>>
>>>
>>
>>
>
>

Relevant Pages

  • Re: SQL 7.0 T-SQL Backup - Simple
    ... If you are already doing a diff and it suites your needs then just change ... the WITH NOINIT option on the diff backup to WITH INIT and it will overwrite ... >> that issues a DIFF backup with the INIT immediately after the FULL ...
    (microsoft.public.sqlserver.setup)
  • Re: Odd backup corruption
    ... I've seen the following bizarre situation with BACKUP on an Alpha PS ... $ diff temp-input.ps temp-backup.ps ... extracting a file from a Backup saveset. ... with similar qualifiers to DUMP for display in BYTE, WORD, LONG etc. ...
    (comp.os.vms)
  • Re: windows 2003 sbs backup problem
    ... IMHO you can spend a lot of money and get little benefit over NT backup. ... Once you have outgrown the ability to put it all on one tape, ... Diff gets everthing that has changed, and does NOT reset the archive bit. ... Assuming that your differential backup will fit on one tape, ...
    (microsoft.public.backoffice.smallbiz)
  • Re: SQL 7.0 T-SQL Backup - Simple
    ... to do a full backup every night so I need a diff or inc. Diff at this point ... seems to just keep adding the diffs to that one backup file. ... >> Sorry wasn't able to find the correct info for this question. ... >> Sorry for the basic question, I thought I would be able to find this ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 7.0 T-SQL Backup - Simple
    ... that issues a DIFF backup with the INIT immediately after the FULL backup. ... > BACKUP DATABASE TO DISK = ...
    (microsoft.public.sqlserver.setup)