Viewing 15 posts - 166 through 180 (of 1,270 total)
Great idea, Perry!
Additionally, you should be backing up the log regularly anyway. the database is in full recovery and log backups are required to mark the inactive portion of the...
September 4, 2012 at 2:10 pm
1. Please start new threads for new questions. Don't piggy back. People are not going to be diligent about reading replies in this thread.
2. What are the settings for the...
September 4, 2012 at 8:46 am
prettsons (8/7/2012)
If you don't have backup then there is only one way to resolve log file corruption that is to rebuild log file. Check this article, it...
September 3, 2012 at 8:59 am
If you fail over and fail back, does it get updated?
Sometimes the metadata update in master does not complete. On a non-mirrored database, I usually take the database offline and...
September 3, 2012 at 8:43 am
It depends. There is no way for us to say whether those rowguid columns serve a function other than replication. If there is already a rowguid column on a table,...
September 3, 2012 at 8:26 am
Where are the witness servers? In the site with the principal or the site with the mirror? If the site with the principal, then I would guess that the mirror...
September 3, 2012 at 8:22 am
durai nagarajan (8/29/2012)
any problem in using DBCC SHRINKFILE?
Yes, using DBCC Shrink[File|Database] on a live tempdb has in some cases caused corruption.
September 2, 2012 at 10:23 pm
DBCC CheckDB is outputting 2 columns that you're not accounting for: RefDbId and RefPruId.
August 29, 2012 at 4:44 pm
I wish I had gotten to this thread sooner. I could have sold popcorn to the spectators and made a small fortune. 🙂
August 28, 2012 at 7:55 pm
Do you have access to the muti-pathing software? Can you see the config to check the number of paths for each LUN?
August 23, 2012 at 1:05 pm
Is the SAN shared with other servers? I've experienced issues like this running backups to a shared SAN because everyone else was backing up their databases at the same time...
August 23, 2012 at 12:24 pm
That number seems high to me. You'd have to be in a lot of leagues to spend that much time. I'm in 4 leagues, and I don't spend half that...
August 22, 2012 at 11:38 am
Adam Gojdas (7/13/2009)
I would really like to see such a mythbusting article along with examples that disprove them. I know I have been guilty of believing some of them...
August 16, 2012 at 10:12 am
The timeout is mostly relevant if you have automatic failover configured. The timeout value is basically the number of seconds that a partner can fail to be contacted before it...
August 8, 2012 at 11:26 pm
The reason you use multiple data files for tempdb is not for disk bandwidth. It is to avoid contention on the allocation pages. Saying that there is no benefit putting...
August 8, 2012 at 8:54 am
Viewing 15 posts - 166 through 180 (of 1,270 total)