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 |
|
robman
Starting Member
6 Posts |
 Posted - 2005-08-18 : 11:52:39
|
| HiI am using MS SQL 2000 database. My transactoin log file is getting full so i am creating a job in ms sql 2000 which backup the transaction log file.I want to modify the query BACKUP LOG PRD TO DISK = 'S:\BackupLogs\PRDbklog.BAK' to include the timestamp at the filename. for example BACKUP LOG PRD TO DISK = 'S:\BackupLogs\PRDbklog<timestamp>.BAK So how could i append the timestamp to the filename? Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-18 : 12:15:09
|
| Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53975 |
 |
|
|
|
|
|
Modify Backup Log SQL query