CV? I raised objections when backups etc were moved to Systems -- don't feel any need ( or use ) in going further with that. As I mentioned...

To add insult to injury, management just took backups/restore/DR away from me on our newest production sql cluster, and handed it to an untrained Systems Team engineer using Commvault Idata...

The two main reasons I don't like it are 1) now that our Systems team handles backups/restores with the Commvault product, you have folks who are not Database Professionals attempting...

Affirmative on having to take a full backup after resuming Full Recovery Mode in order to resume transaction log backups -- verified that through testing.

I need to read more about...

No. Setting simple recovery before the full backup just lets me get to bed earlier as someone else is handling the backup. I just wanted to make sure...

How about this approach?

Before Conversion:

A. take final transaction log backup

B. execute CHECKPOINT

C. Set simple recovery mode

D. take pre-conversion Full Backup

After the conversion I know we must resume full recovery mode...

Thanks for the feedback. I was just getting at whether to:

a. switch to simple, take full backup, run conversion or

b. take full backup, switch to...

Historically, the prod backup share has been visible to certain people who can restore copies of the prod database to dev sql servers. This weekend we start a...

We've had a situation for years where development priorities outweighed everything else. Now with more audits ( such as SAS70) and clients asking questions there is a movement to...

All databases/backups are either on the Netapp disk device or on Commvault storage. There is no sql data on the two sql cluster nodes that will get upgraded.

All of our sql 2005 instances are at SP3 and the one 2008 is at SP1

That's kind of what I thought. thanks

One of the advantages of using the Commvault Idata Agent ( or agents like it ) would be if you no longer had to use space on your production disk...

We won't have a commvault SQL Idata Agent license on any dev boxes, so to get copies of the production DB there we'll have to jump through other hoops. ...

"The only way we have been able to do backup and restores (at least the only access we have been granted) has been to do the backup in CommVault and...