Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Differential backups in Maint Plan??
Message
From
12/09/2006 07:50:48
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Differential backups in Maint Plan??
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01152968
Message ID:
01152968
Views:
66
I am not finding any option to do differential backups in the maintenance wizard. Using that allows for different filenames for each backup (i.e. the date). I have several very large databases that I would like to do this way. Any suggestions??

Also, why is it not a good idea to do set shrinking of database in maintenance when the db has large number of transactions??

Help is always appreciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Reply
Map
View

Click here to load this message in the networking platform