Modify Backup SQL QUERY

0 pts.
Tags:
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
ASKED: August 16, 2005  11:18 AM
UPDATED: August 16, 2005  11:38 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Knowlegde
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following