Viewing 9 posts - 16 through 24 (of 24 total)
GilaMonster (9/28/2011)
Database mirroring comes to mind. The database on the second server is still unavailable (because it's in the restoring state), the mirroring keeps the two in sync.
Yeah, that was...
September 28, 2011 at 1:13 pm
Elliott Whitlow (9/28/2011)
sickpup (9/28/2011)
By normal failover clustering, do you mean at the o/s level? Or is there something else in SQL, besides the "SAN-required" clustering that I'm missing?
Yes, I mean...
September 28, 2011 at 12:40 pm
Elliott Whitlow (9/28/2011)
sickpup (9/28/2011)
If our primary concern is having the ability to failover to a different database server in the event of a...
September 28, 2011 at 11:04 am
Hmmm... ok, let me phrase it this way.
If our primary concern is having the ability to failover to a different database server in the event of a problem, but we...
September 28, 2011 at 9:06 am
Just a quick note to say that everything went smoothly over the weekend. I identified and dropped the nc indexes on the bad DB files. Then, ran shrinkfile, the index...
February 21, 2011 at 9:02 am
Great info - thanks all. I knew shrinkfile would cause fragmentation... just didn't know how bad it would be.
So, here's the gameplan:
Identify the NC indexes on the affected DB Spaces...
February 17, 2011 at 4:29 pm
TheSQLGuru (2/17/2011)
If you really do need the space (quite likely) and can stand the downtime, I would drop all NC indexes, shrink...
February 17, 2011 at 11:19 am
Er, uh... well, this is embarrassing.
So, looking back through the settings on the index rebuild maintenance task, I see that "Change free space per page percentage to:" is set at...
February 17, 2011 at 9:06 am
Just as an FYI, in case it helps anyone...
We recently had this same problem. One of our DBs was stuck in a "Recovery Pending" state following a sudden (and unusual)...
November 1, 2010 at 4:23 pm
Viewing 9 posts - 16 through 24 (of 24 total)