Sunday, March 11, 2012

Differential Backup via Maintenance wizard

(If this is not the correct forum please point me in the right direction)

I am trying to schedule a Daliy differential backup using the Maintenance Wizard. This works fine for me, however I do not see where I can actualy speficy the file name I want to use for the differential backup

I notice that SQL 2005 will add the date and time for example MyDatabase_backup_200703191330. I would like to use a different name, for example MyDatabase_DiffBackup_DateTime. How can I specify this, I am not able to modify the T-SQL that is generated. is there a way to do this? Modify the T-SQL

Do I need to specify "backup databases across one or more files option" if so where do i specify the file name.

Should I create the job manually and execute to a T-SQL statement where I can specify the file name?

Thanks

-javahar

Create a Job and write T-SQL Code for Differential Backup will be great and less problem

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

No comments:

Post a Comment