如何更改备份文件的时间戳？ [英] How to change time stamp for the backup files??

问题描述

我正在使用BizTalk备份作业执行BizTalk数据库备份，并计划每小时运行一次。现在，.bak文件有UTC时间格式但是我想要我们的本地时间戳。我正在使用下面的脚本：

执行[dbo]。[sp_BackupAllFull_Schedule]'h'/ *频率* /，'BTS'/ *名称* /，'D：\ backup'/ *备份文件的位置* /，'1'/ * ForceFullBackupAfterPartialSetFailure * /，'BackupHour'/ *本地时间为备份进程运行* /

在上面的脚本中，如果我想要FULL备份的.bak文件的本地时间戳，然后应该更改什么？

注意：对于日志备份.bak文件，我在使用'1'时会得到本地时间戳在脚本下面：

执行[dbo]。[sp_MarkAll]'BTS'/ *日志标记名* /，'D：\ Backup'/ *备份文件的位置* /，'1'/ *使用本地时间戳作为备份日志* /

感谢

Hi,

I'm using the BizTalk backup job to perform BizTalk databases backup and it scheduled to run every hour. Right now, the .bak files have UTC time format But I want to have  our local time stamp. I'm using the below script:

exec [dbo].[sp_BackupAllFull_Schedule] 'h' /* Frequency */, 'BTS' /* Name */, 'D:\backup' /* location of backup files */, '1' /* ForceFullBackupAfterPartialSetFailure */, 'BackupHour' /* local time hour for the backup process to run */

In the above script, If I want the local time stamp for the .bak files of FULL Backup, then what should I change?

Note: for Log backup .bak files, I'm getting local time stamp when I use ' 1' in the below script:

exec [dbo].[sp_MarkAll] 'BTS' /* Log mark name */, 'D:\Backup' /* location of backup files */,'1' /* use local time stamps for the backup log */

thanks

推荐答案

安德鲁。我不认为他的问题是在一天中的特定时间完成备份，而是在创建的备份的文件名中获取本地时间。

ardakolan，我认为你不能改变这一点。我唯一能想到的是添加另一个执行一些脚本的步骤，这些脚本会为你改变这些。

Hi Andrew. I don't think his issue is getting the backup done at a specific time of day, but rather getting the local time in the filename of the created backup.

ardakolan, I don't think you can change this. The only thing I can think of is to add another step that executes some script that will change these for you.

这篇关于如何更改备份文件的时间戳？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！