Viewing 15 posts - 3,136 through 3,150 (of 6,676 total)
Well, first we need to deal with your misunderstanding.
Mirroring does not restore transaction log backups. Transactions are sent to the mirrored database and applied as fast as the system...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2011 at 3:09 pm
Lee,
ROW_OVERFLOW_DATA - Holds variable length data stored in varchar, nvarchar, varbinary, or sql_variant columns that exceed the 8,060 byte row size limit."
I believe the above is related to a single...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 14, 2011 at 5:45 pm
Yes, I can think of ramifications - index fragmentation, file fragmentation - and basically, just a waste of time and resources.
If you are constantly shrinking a file - and then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 8:35 pm
It is just a numbers table.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 5:01 pm
sqlnaive (6/13/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 4:43 pm
4u.chethan (6/13/2011)
we can only find the status but i want to know till which transaction log backup its been mirrored.
is there any way i can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 2:17 pm
sqlnaive (6/13/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 2:10 pm
Lee Crain (6/13/2011)
Sorry I took so long to respond on this subject; I've been very busy.
I knew I'd read documentation to the contrary of your assertion. Adding data to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 13, 2011 at 1:55 pm
sqlfriends (6/12/2011)
But for sql profiler trace, can you confirm it is easy to run on my local...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 12, 2011 at 5:43 pm
In addition to Steve's advice, you need to put together the plan for the downtime.
Step 1: Document cluster configuration
Step 2: Document service accounts used for each service
Step 3: Document AD...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 12, 2011 at 10:49 am
I really don't know where these articles are that recommend letting SQL Server manage the memory. Anyways, here is what I have found to work on x64 hardware:
With lock...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 11, 2011 at 11:05 am
I guess I still don't get it - you are looking at modifying when you backup the databases, and not when that is copied to tape.
I would be worried about...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 11, 2011 at 10:17 am
Check the dependencies on the service - you are probably missing one or more that are required for SQL Server to start.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 11, 2011 at 9:50 am
One thing you also need to understand is that if that value is always a low value (e.g. .7 MB like you have), it is probably a good indication that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 10, 2011 at 3:09 pm
Brandie Tarvin (6/9/2011)
Too many people don't...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 10, 2011 at 2:53 pm
Viewing 15 posts - 3,136 through 3,150 (of 6,676 total)