Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-02 : 08:35:38
|
David writes "Is there a way to include the time in the name of a backup file? I want to backup the transaction logs every hour to a different file in the backup directory. I would like to create one job in SQL Server Agent to do the backups every hour. My problem is that I don't know how to include time in the name of the backup file:
backup log model to file = 'c:\backup\ '
Is this possible or do I have to create different jobs for each hourly backup?" |
|
|
|
|
|
timestamp in backup file names