If the data is static and I add a secondary data file, won't SQL try to automatically balance the two data files? Thanks.

TRACEY (1/18/2009)

---

Glad to hear your SP3 went well, just before i do my install,

I have three physical (ACTIVE, ACTIVE and PASSIVE).

Both ACTIVE fail to PASSIVE.

So did you just leave...

Preston (1/17/2009)

---

Since I have two instances, I would have to install it once for each instance. In this case of active/active, I would start the SP3 from the active...

Since I have two instances, I would have to install it once for each instance. In this case of active/active, I would start the SP3 from the active nodes,...

Per Microsoft, "Maps an existing database user to a SQL Server login. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in...

Grant,

Just read your two articles and would like to say they were well written and cleared some things up for me. Thanks!!

GSquared (9/5/2008)

---

Preston (9/4/2008)

---

After running the above codes on a VM, I received "The file "ExampleDB" has been modified in the system catalog. The new path will be used the next...

We have SQL agent licenses for our backup solution/CommVault. What do you guys think about letting CommVault agent backup SQL versus maintenance plan? I'm leaning towards doing it...

After running the above codes on a VM, I received "The file "ExampleDB" has been modified in the system catalog. The new path will be used the next time the...

Man, you guys ROCK! I'm glad I found this forum full of helpful people. Again, thanks. 😀

Lynn Pettis (9/3/2008)

---

Lookup RESTORE in BOL. If you still don't understand, let...

What does FILE = 1, NOUNLOAD, & STATS = 10 mean in a Restore statement? Thanks.

Matt, you hit the nail on the head with what I'm asking. Thank you to you and Grant for the help.

I cannot access the first link with the error below.

"Sorry, an error has occurred

You do not appear to be the author of this content. You can find your contributions in...

Guess my main question is what is best practice on maintenance plan? I currently have it database then logs and thinking about reversing it. Thanks.