Viewing 15 posts - 3,301 through 3,315 (of 6,676 total)
annasql (4/6/2011)
I hope there is a microsoft article explains this in detail. Because we are planning upgrade all our sql 2005 to 2008 on windows...
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 6, 2011 at 10:11 pm
CirquedeSQLeil (4/6/2011)
Jeffrey Williams-493691 (4/6/2011)
The job_id is stored in the table: sysmaintplan_subplans and 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
April 6, 2011 at 6:10 pm
In addition to what Perry has asked - are the services on each node set to manual startup or automatic?
And - what is the version of the OS you are...
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 6, 2011 at 6:05 pm
I found a way to relate maintenance plans to their associated agent jobs. It is quite simple...
The job_id is stored in the table: sysmaintplan_subplans and can be used directly...
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 6, 2011 at 3:55 pm
Okay, when I first saw this message and thread - I started wondering about this myself. So, I looked around and figured out what is going on.
To explain, I...
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 6, 2011 at 3:48 pm
One of the things to be aware of is how the maintenance plan history viewer works. It works based upon the maintenance plan - and not the sub-plans.
If 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 6, 2011 at 2:49 pm
Not that I am aware of, you can check to see if there is an identifier in the sysdtspackages90 table that would relate to the identifiers in the sysjobs tables.
I...
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 5, 2011 at 8:05 pm
I don't see any issues with using 'sa' as the owner of agent jobs.
As for a query, it is included in my previous post.
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 5, 2011 at 7:36 pm
Grant Fritchey (4/5/2011)
True, but I prefer to not let anyone have privileged access to the server except other DBAs.
Of course, I would prefer that also - but I have various...
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 5, 2011 at 7:35 pm
When a maintenance plan is created, it will be owned by the user logged into the system when it is created.
The owner will not be changed after the fact. ...
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 5, 2011 at 2:26 pm
Grant Fritchey (4/5/2011)
Can you try using restricted user instead of single user? I've seen applications that constantly refresh their connection so they can squeek in before you start the restore.
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 5, 2011 at 2:17 pm
Lookup substring in books online. If you really need the answer as February and not '02', then you are going to need to convert the period into a 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
April 1, 2011 at 4:50 pm
Lowry Kozlowski (4/1/2011)
We didn't want to break anything, and once you change the compatiblity you cannot go back.
The compatibility level can be changed back, if needed. When 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 1, 2011 at 1:32 pm
Lowell (3/30/2011)there's no way one system can store the same data, in the same data type, in a radically smaller amount of space than the other system.
Not quite true...SQL Server...
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 30, 2011 at 7:12 pm
If you have purchased per processor licensing for 2008 R2 - you are already licensed on that system and can install multiple instances with no additional cost.
Double check your licensing...
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 30, 2011 at 7:08 pm
Viewing 15 posts - 3,301 through 3,315 (of 6,676 total)