Database Backup

Hi,

Currently i schedule my SQL sever agent to do database backup once in a few days with the default backup file name to ABC. Hence everytime, it will overwrite the previous file. Is there a way for me to auto append date time at the back of my default file name? Eg will be ABC_DD_MM_YYYY
Thanks!

Regards,
weihann.If you right click your database name, choose all tasks -backup database, you can find what you want.

Database Access

Dear All,

I Have two SQL Server ABC and XYZ and i have changed the SA password of both the servers.

I have added link server on the both the servers.

When i execute a link server query in a SQL Query Analyser on either server it works, but when i use the same query in a job, then it fails.

So anyone can help in the above problem.

Regards,
VinayakThe sql server service accout needs to be granted authority|||Hello,

Can u help me in the same.......