Home > IT Answers > Microsoft Windows > Modify Backup SQL QUERY
Knowlegde
0 pts.
 Modify Backup SQL QUERY
Desktops, Development, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Hi I want to modify the query BACKUP LOG PRD TO DISK = 'S:BackupLogsPRDbklog.BAK' to include the timestamp at the filename. for example BACKUP LOG PRD TO DISK = 'S:BackupLogsPRDbklog<timestamp>.BAK So how could i append the timestamp to the filename? Thanks

Software/Hardware used:
ASKED: August 16, 2005  11:18 AM
UPDATED: August 16, 2005  11:38 AM
RELATED QUESTIONS
Answer Wiki:
There are numerous ways to accomplish this, but each are dependent upon the mechanism (for example: SQL Editor) used to submit this command. Check the command mechanism documentation for variables / parameters. The information is not usually listed in the specific command, but rather in a general information section.
Last Wiki Answer Submitted:  August 16, 2005  11:31 am  by  UncleLarry   0 pts.
All Answer Wiki Contributors:  UncleLarry   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi
I am new to SQL.Could you please provide me the
documentation from where can i get further information.
Actually i am trying to create a job in MS SQL SERVER
2000 to take transaction log files backup.

Thanks

Knowlegde
 0 pts.