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 |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-06-30 : 07:36:44
|
I selected one database, it's recovery model is "simple". when I create maintenance plan, the wizard allows me to select the option,"Ship the transaction logs to other SQL Servers (log shipping)"(-- It should not allow me, When I deselecting it and then selecting the check box become disable.--)Finally the Maintenence Plan job fails because the recovery model is Simple.Is it a bug If you have time please check it. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-30 : 08:51:09
|
| Is it a bug? Yes....it's a bug called the Maintenance Plans. Just use scripting and jobs for this. Tara Duggan has posted a great script on here for this. Why mess with the dysfunctional Maintenance Plans.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
LogShip - Recovery model "Simple" (error)