(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