June 18, 2009 at 1:22 pm
Good day everyone.
My question is:
How can I create a sql backup where backup file would have ONLY a backed up database name.bac?
No date stamp in the backup file name.
Is there a settings in a Maintenance Plan?
I need to use Maintenance Plan, the reason is that we have more than 200 dbs.
June 18, 2009 at 1:27 pm
slava davidchuk (6/18/2009)
Good day everyone.My question is:
How can I create a sql backup where backup file would have ONLY a backed up database name.bac?
No date stamp in the backup file name.
Is there a settings in a Maintenance Plan?
I need to use Maintenance Plan, the reason is that we have more than 200 dbs.
I'm not sure how to do this using maintainance plan. What i can think of is a customized script to take backups for all databases which can be scheduled. In ur case, special thought needs to be given to NOINIT clause depending on whether u want ur backup files to be appended or overwritten.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply