Viewing 15 posts - 5,551 through 5,565 (of 6,676 total)
It is not easy to understand what you are trying to do without examples. Please review the article that I link to in my signature on how to 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
March 16, 2009 at 2:23 pm
right-click on the maintenance plan and view history - all steps and the duration of each step is in there.
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 15, 2009 at 4:52 pm
Verify that you have enabled remote connections to this instance of SQL Server. Also verify that you are connecting to the right instance.
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, 2009 at 1:20 pm
larry Hennig (3/13/2009)
Unfortunately, powershell...
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, 2009 at 5:28 pm
larry Hennig (3/13/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
March 13, 2009 at 4:59 pm
larry Hennig (3/13/2009)
[/p][p]
I do backup the system databases and recovery them as part of...
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, 2009 at 4:35 pm
What is the error you are getting?
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, 2009 at 4:18 pm
The only real option you have is to use a SQL Agent job to run your script, and in the next step call your maintenance plan.
The other options are xp_cmdshell...
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, 2009 at 4:17 pm
Most likely the reason it is taking so long is that it has to pull all of the data in the remote table locally to perform the filtering, before 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 13, 2009 at 4:12 pm
You have to setup EM to include indexes when scripting - has that been done?
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, 2009 at 3:44 pm
In a disaster recovery situation, we re-install SQL Server back to the appropriate version (all service packs/cumulative updates). Once installed, we then restore the databases from our backups up...
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, 2009 at 3:42 pm
You can't - the only time you will get an error in the maintenance plan is if the job cannot be started.
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, 2009 at 3:17 pm
I agree with Lynn - I prefer the second method just because it is clearer what you are doing.
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, 2009 at 3:14 pm
foxjazz (3/13/2009)
Yes shortening of stuff...
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, 2009 at 3:12 pm
seth.rothman (3/11/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
March 11, 2009 at 2:36 pm
Viewing 15 posts - 5,551 through 5,565 (of 6,676 total)