Viewing 15 posts - 5,341 through 5,355 (of 6,676 total)
Verify the settings on the AD account - make sure the password is not getting reset or the account is not getting locked out.
The account could be getting locked if...
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
April 20, 2009 at 10:26 am
Bob Hovious (4/20/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
April 20, 2009 at 9:46 am
WebTechie38 (4/17/2009)
I am learning so much from this forum! I like to research and investigate and come up with a strategy or a thought. Then I bounce...
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
April 19, 2009 at 7:52 pm
Yes - all it will take is a single weekend where you don't get the notifications of the job failures and you will no longer have any backups available online.
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
April 19, 2009 at 10:38 am
Yes - I have a suggestion. Read the article I link to in my signature.
I can guarantee that you do NOT want to loop through the tables. Whatever...
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
April 18, 2009 at 9:22 am
Phil Parkin (4/17/2009)
Jeffrey Williams (4/17/2009)
...
The permissions on the services appear to be correct - and shouldn't need to be changed. ...
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
April 17, 2009 at 8:21 pm
I see - you are using the query builder, which does stupid things like that. What you should do is just open a new query window and write 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
April 17, 2009 at 8:15 pm
As Lynn pointed out - change your join to an outer join. Also, get rid of the TOP 100 PERCENT - it is doing nothing at all for 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
April 17, 2009 at 5:25 pm
The error message is telling you what the problem is:
The process exit code was "1" while the expected was "0". End Error
Most likely, the utility/script you are using is...
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
April 17, 2009 at 5:22 pm
That is correct, once you have fully tested the cluster failover - all drives will be visible from both nodes and only accessible from the node where the resource exists.
This...
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
April 17, 2009 at 4:18 pm
d short (4/17/2009)
I understand that SQL Server treats blanks as '1/1/1900', at least in display. What I don't understand is the reverse, 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
April 17, 2009 at 4:15 pm
The drives will be visible but not accessible from node 2.
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
April 17, 2009 at 3:36 pm
Not sure I follow you - with your example script, the only date column that is blank is the one where you don't insert anything:
insert #testdate2 ( descr) values('null')
The date...
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
April 17, 2009 at 2:49 pm
Lynn Pettis (4/17/2009)
I think he-who-should-just-go-away may be back. I wonder how he'll respond to my comment?
Hard to tell - then again, who can even understand him when he's actually...
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
April 17, 2009 at 2:42 pm
Don't change the login properties using the services applet. Use SQL Server Configuration Manager which will make sure the changes are made to all of the appropriate locations.
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
April 17, 2009 at 2:29 pm
Viewing 15 posts - 5,341 through 5,355 (of 6,676 total)