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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-10 : 07:37:16
|
| Colin writes "I am new to SQL Server 2000 so feel free to treat me as an idiot.I have an instance with a number of databases. All of them are backed up by the same maintenance plan (MP).One of them I have changed to be read-only. At the same I removed it from the overall MP and set up a new one which just backs up the Database up on an infrequent basis (belt & braces I know).Only it doesn't. No error message, no record in the history table, nothing.I based the MP on the existing one, via the wizard, but have obviously missed something.Any ideas?" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-11-10 : 14:21:56
|
| Have you tried the backup of the RO database manually? If not, you should do and see what happens.BTW, if its read-only, why do you need to back it up more than once? As soon as you have a known-good backup, you're done, right?ThanksPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-10 : 15:05:18
|
"why do you need to back it up more than once"Possibly because you've used the "Backup all User Databases" option.Paul, I think this is a weakness of Maintenance Plan in SQL2000. If databases are READ_ONLY, OFF_LINE etc. or have SIMPLE recovery model, but the maintenance plan is set up to do TLog backup, or "fix simple errors" then setting up a "Backup ALL User Databases" tends to run-out-of-road.We have our own SProcs to make backups and take care of these scenarios, but I'm supposed to know what I'm doing  . From my perspective I would be chuffed to hear (i.e. from a save-newbies-from-themselves perspective!) that SQL2005, or subsequent R&D, is going to make the Maintenance Plan Wizard more robust in this regard.Kristen |
|
|
|
|
|
|
|
|
Maintenance Plan doesn't backup database