Viewing 15 posts - 4,036 through 4,050 (of 6,676 total)
Those errors are not related to SQL Server - rather, they are errors with your IO system and will eventually cause corruption in your databases.
You need to call MS support,...
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
March 14, 2010 at 10:56 pm
Well, that depends on the table. Sounds like this table is the most active table in the database - but you would know better than I 😉
Remember, there could...
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
March 14, 2010 at 10:12 pm
smesser (3/14/2010)
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
March 14, 2010 at 5:16 pm
Here is the link to the 2008 documentation: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/html/309b9dac-0b3a-4617-85ef-c4519ce9d014.htm#Configure_services
You'll note that it states the following:
Set as manual in failover cluster configurations.
After the table of services and startup types. 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
March 14, 2010 at 2:28 pm
iamthemanx (3/14/2010)
I know for sure is a security stuff, the way SSMS2008 is reading that from the SQL2005 instance. But why...
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
March 14, 2010 at 10:12 am
smesser (3/13/2010)
I am not familiar with instant initialization so I will have to look that up.
The table has two indexes (both Non-Unique, Non-Clustered):...
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
March 13, 2010 at 8:03 pm
If you are allowing your database to autogrow - that would definitely be an issue. You should manually grow the file out, monitor and grow it manually as needed.
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
March 13, 2010 at 6:34 pm
You need to stop one of the processes here - you are causing problems with the backup chain and won't be able to restore the system when you need to.
Differential...
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
March 13, 2010 at 3:21 pm
Yes, the services must be set to manual so cluster adminstrator can manage stopping and starting the services. That's what it is supposed to do - because on a...
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
March 13, 2010 at 3:18 pm
You can create a SYNONYM for that object - as in:
CREATE SYNONYM dbo.MyTableName FOR [linked server].db.dbo.TableName;
Then, in your code you reference your synonym:
SELECT {columns} FROM dbo.MyTableName;
If the linked server changes,...
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
March 13, 2010 at 3:11 pm
I would verify that your new user account for the agent was added to the right local windows groups. There is a specific group for the Agent and 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
March 12, 2010 at 7:53 pm
To add to what Gail posted - the term ONLINE for index rebuild has nothing to do with whether or not the database is online. It means that 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
March 11, 2010 at 2:45 pm
bret.quackenbush 86227 (3/9/2010)
One other note, if you a running SQL Server Std x64, in order to get the 'Lock Pages in Memory' feature to work you must be on SP3.
And...
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
March 9, 2010 at 1:40 pm
pshaship (3/8/2010)
I think you may need to do some investigation as to why your indexes are fragmenting so fast. Are you doing database shrinks?
I'm NOT doing any database shrinks and...
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
March 8, 2010 at 8:23 pm
Again - this is just one persons personal observations, but it is a person whose opinion I respect (a lot) 🙂
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
March 8, 2010 at 4:28 pm
Viewing 15 posts - 4,036 through 4,050 (of 6,676 total)