I'm talking about the following: "When the database is enabled for READ_COMMITTED_SNAPSHOT, all queries running under the read committed isolation level use row versioning, which means that read operations...

I'm not very happy with commvault's inflexibility. Some of that may be due to the System Team's lack of experience with the product and with sql server terminology/concepts. ...

Thanks for all the feedback. The first thing I have to do is run a test to see how Commvault reacts to switching the recovery model. I...

It's not the size of the log backups that concern me since they go to separate disks, it's the size of the log file itself.

According to this msdn article ALTER...

I'm not happy that I can no longer do native sql backups and that our Systems Team now handles things with Commvault, but that's another topic. I have...

I used xp_readerrorlog to create a job that emails me log extracts. But since I'm no longer responsible for backups, restores or disaster recovery, I'm not...

Commvault does show in the sql log when it does backups etc. You'll see an entry with "virtual device"

Database differential changes were backed up. Database: xxxxx,...

These are now backups created with the commvault agents. Our Systems team has taken over all sql backup/restore/disaster recovery for our main production environment. They're learning slowly but...

As an "acting DBA" who doesn't feel quite ready to be the Senior DBA, I've suggested we make use of consultants as needed, if the funds or justification just wasn't...

Our IT management has talked about "snap" capabilities with our Netapp disk device. This reminds me of my post the other day about "DBA - Phantom job title." ...

I've found it best to refer to transaction log backups as transaction log/incremental backups. I work with IT folks from many different backgrounds, along with managers with little technical...

Tech 23202: Simple recovery mode minimizes the amount of data written to the log file and does not allow transaction log backups. I would think this is your...

It would be pretty easy for me to add a switch to bulk-logged before reindexing every Saturday night and switch back to full-recovery afterwards, but I have no idea what...

Did I understand correctly that if you went to bulk logged ( or simple?) before reindexing, you could then resume full recovery and log backups afterwards without doing anything...

Dice.com