Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2004-03-02 : 23:53:21
|
| Hello All,Is it possible to schedule Differential backup and Transactional Log backup thru a maintenance plan..??? Or is it that only a full database backup can be scheduled using the same.RegardsNishith |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-02 : 23:57:15
|
| Log backups yes, differentials no. But do yourself a favor, don't start using maintenance plans if you're just beginning, and stop using them if you have been. Learn the BACKUP DATABASE command, play with jobs, write your own code to do it. It's a lot easier than you think and far less problematic than maintenance plans. I have had so much trouble with sqlmaint that I refuse to use it anymore, and once I sat down and wrote my own I could only kick myself for not doing it sooner. |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-03-03 : 08:29:28
|
| And if you want a good example of the headaches, just look down a few posts for my question on using maintenance plans to reindex. Grrr. |
|
|
|
|
|
|
DB Maintenance Plan...