Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do i schedule a daily backup?
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01320160
Message ID:
01320165
Views:
18
>>>Hi
>>>When i right-click on a database and select the Backup in the Tasks menu, i can backup that db to a local directory, which is what i want.
>>>When i try to run the same task again to the same directory, i get an error message "...not a multiple backup set..." or something like that.
>>>Furthermore, i would like to run this task every day at a specific time, either incremental or overwriting the existing backup.
>>>
>>>TIA
>>>Jaime
>>
>>
>>Expand Management node in Object Browser in SSMS.
>>Right-Click on Maintenance Plans node.
>>Choose Maintenance Plan Wizard from the menu and follow the wizard.
>
>Geez Boris, took you 9 minutes, what are you, asleep?? :-)
>Many thanks for the help
>
>Jaime

Nope,
I am at work. The working day just begins :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform