SQL 2000 - Databases getting backed up multiple times
Tech-Archive recommends: Fix windows errors by optimizing your registry
I see in my server logs that some databases are getting backed up multiple
times during the night. For example, the MASTER DB I have set to be backed
up at 12:15 in a maintenance plan. The log shows it backed up at 12:20,
3:07, and 4:15.
Also, I see databases and transaction logs getting backed up that are no
longer in any maintenance plan.
What's going on here?
--
Thanks!
.
Relevant Pages
- Re: Question about Exchange Logs and DBs Best Practice
... Yes, even from 5.5 days, the primary reason you separate logs from databases ... For Exchange news, links and tips, check: ... > If you put ALL the databases in one RAID set, then if that one RAID set ... (microsoft.public.exchange2000.admin) - Re: Disk Partitioning/RAID recommendations
... Probably the best thing you can do is to separate the databases and logs ... However, you may be tight for space on the mirror this way, so you could ... Repartitioning drives as we move from Exchange 2000 to ... (microsoft.public.exchange2000.setup.installation) - Re: E2K7 SP1 Configuring Storage
... So any info you can provide on how NetApp has their databases or storage ... One Volume has one LUN in it and one database inside that LUN. ... Put the SNAPINFO on the same LUN as the transaction logs. ... talk to NetApp about your aggregates. ... (microsoft.public.exchange.setup) - Re: Checkpointing Not Happening in Simple Recovery Model
... Yes, you are right, I read that Michelle is writing about logs not log, is ... there possibility that she looks at transaction logs on databases with full ... > You cannot set the recovery model in tempdb. ... >> We have at least two databases on this server in simple recovery model. ... (microsoft.public.sqlserver.server) - Re: RAID5 Data disk and Mirrored Controller disks -- Best Practices?
... How big do you expect the log files to be? ... Put the databases and logs on the RAID 5 volume. ... if I have a RAID5 data partition on a separate SCSI channel and then ... (microsoft.public.sqlserver.setup) |
|