Spoke with our Server guys. They feel that the dependencies are set correctly, but testing this would have to be done on a Sunday because in a cluster environment,...

Indianrock (11/6/2009)

---

One question: do my differentials and incrementals determine which full or diff they are "working from" by looking in msdb? Or does sql actually look on the...

As we seem to move ever closer to replacing native sql tools/backups with Commvault, I was asked to provide restore times for many of our production databases. As I...

The real problem is that System types may either not understand enough to restore databases properly, taking into account on what drive the data and log files go, or not...

I haven't used that product but most DBAs prefer to use native sql server tools like Management Studio to schedule and restore backups. Then your Systems people can backup...

We have Spotlight and I need to learn more about it because sometimes when I look at history for a particular server and drill into User/Sessions the processes that were...

Looks like log shipping may be possible with Commvault, but seems messy with agent installs etc. http://documentation.commvault.com/commvault/release_7_0_0/books_online_1/english_us/features/disaster_recovery/cs/cs_sql_separate.htm

I'm not the network tech. I'm a production support person who has been filling in as the "DBA" for years. We are approaching the time where two of...

My thoughts exactly Brandie. I'm recommending that I be allowed to test the Commvault GUI/backup product for a while, but that the responsibility should remain with someone who is familiar...

In our company there is no on-site full-time DBA so anything that will help me check things and be alerted to problems quicker is desirable. If it can...

We're testing the latest Commvault sql backup product. So far I don't like the idea. The backup goes to the Commvault "nearline" device in a format that normal...

I forgot to mention that the test we just did was in preparation for a large-scale project where we will split the database out into numerous new files for better...

Not at all. In fact, if I learn something, ruffle away. I was trying to minimize impact to our production environment yesterday ( by not setting to simple...

Jeffrey Williams-493691 (10/26/2009)

---

ALZDBA (10/26/2009)

---

Indianrock (10/26/2009)

---

SOLVED ! thanks for your input Gail, we will have to consider smaller inserts. I looked in our Spotlight tool and noticed the...

SOLVED ! thanks for your input Gail, we will have to consider smaller inserts. I looked in our Spotlight tool and noticed the spid of the oldest...