Post reply

Want local time stamp for the .bak files

  • September 21, 2009 at 6:23 pm

    #385402

    Hi,

    I'm configuring BizTalk Backup job and by default it creating the .bak files with UTC time stamp.

    Could you please advice what should I have to change in order to get Local time stamp instead of UTC time stamp??

    exec [dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */, 'BTS' /* Name */, '' /* location of backup files */, 0 (default) or 1 /* ForceFullBackupAfterPartialSetFailure */, 'BackupHour' /* local time hour for the backup process to run */

    1. Frequency: The default is d (daily). This is the recommended setting. Other values include h (hourly), w (weekly), m (monthly), or y (yearly).

    2. Name: The default is BTS. The name is used as part of the backup file name.

    3. Location of backup files: Replace '' with the full path (the path must include the single quotes) to the computer and folder where you want to back up the BizTalk Server databases.

    ImportantImportant

    To avoid potential data loss, you should specify a computer for your backup that is different from the computer with the original data.

    ImportantImportant

    If you specify a local path, then you have to manually copy all the files to the same folder on the destination system whenever the Backup BizTalk Server job creates new files. If you specify a remote path, it must be a UNC share such as \\\\, where is the name of the server where you want the files to be backed up using the Backup BizTalk Server Job, and is name of the shared folder.

    4. Force full backup after partial backup failures: The default is 0 when not specified, which means that if a log backup fails, no full backups are done until the next full backup frequency interval is reached. Replace with 1 if you want a full backup to be made whenever a log backup failure occurs.

    5. Local time hour for the backup process to run: The default is NULL when not specified, which means that backup job will not be associated with the time zone of the BizTalk Server computer and will run at midnight UTC time (0000). If you want to backup to run at a particular hour in the time zone of the BizTalk Server computer, specify an integer value from 0 (midnight) to 23 (11 PM) as the local time hour for the BackupHour parameter.

    Thanks

  • September 22, 2009 at 12:12 am

    #1056565

    Ohh its BizTalk..ummm.Lets see if somebody answers it.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • September 22, 2009 at 4:40 am

    #1056671

    ok, I take back what I posted originally.

    This link explains the issue and how to fix it.

    http://support.microsoft.com/kb/936187

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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