Viewing 15 posts - 4,861 through 4,875 (of 6,676 total)
Was this database upgraded from SQL Server 2000? If so, have you run DBCC UPDATEUSAGE and DBCC CHECKDB ... WITH DATA_PURITY?
Since you are using the DETAILED flag, are you...
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
July 7, 2009 at 8:15 pm
If your table is small - it will never be defragmented fully. How large is this table in pages?
The general rule is that you won't see any benefits 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
July 7, 2009 at 5:59 pm
What version of SQL Server 2005 are you using? Earlier versions required SQL Server Agent Alert system to be configured before the Notify Operator task would work.
This was fixed...
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
July 7, 2009 at 4:43 pm
First, if the variance column is always derived - then I would recommend creating a computed column instead of updating the value in that column. Example:
CREATE TABLE #DeriveVariance
(
ValueA INT,
ValueB...
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
July 7, 2009 at 2:22 pm
mpv (7/7/2009)
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
July 7, 2009 at 2:15 pm
As long as you set the max memory for each instance so that you are not consuming all of the available memory and you have enough resources to support multiple...
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
July 7, 2009 at 1:56 pm
Have you applied the patch found at: http://support.microsoft.com/kb/921106 yet?
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
July 7, 2009 at 11:30 am
What are you going to do with all columns and all 25 million rows? You can't possibly work with that much data.
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
July 6, 2009 at 5:40 pm
The issue you outline here is not the only issue, nor in my opinion is it the worst case. The worst case is when you have data movement occuring...
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
July 6, 2009 at 5:36 pm
You cannot backup the master database with a differential backup. You can only back up the master database with a full.
There is no reason to backup system databases with...
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
July 6, 2009 at 5:26 pm
rob mcnicol (7/6/2009)
why is it that during a failover the...
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
July 6, 2009 at 5:11 pm
I don't know whether or not you can upgrade from Workgroup to Enterprise. I guess you could try it and see what happens.
However, I don't think you really need...
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
July 6, 2009 at 12:43 pm
Your problem is due to it being the RTM version. I am not sure which service pack included the option, but it was not included in the RTM version.
You...
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
July 6, 2009 at 12:32 pm
My guess is that you don't have any available space in the data file. The reason the initial size is growing is because you are experiencing autogrowth events.
I am...
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
July 6, 2009 at 12:02 pm
What version are you currently running on the Workgroup Edition? Is it SP2 or greater?
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
July 6, 2009 at 11:32 am
Viewing 15 posts - 4,861 through 4,875 (of 6,676 total)