SQL 2008 R2: Agent XPS component is turned off as part of the security configuration of this server.

To correct this
Open a new query and paste the following:

In the query window type the following:

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO
RECONFIGURE
GO

After you run it you should expect to see the following in the message window.

Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option ‘Agent XPs’ changed from 0 to 1. Run the RECONFIGURE statement to install.

If you want to disable either just replace the 1 with a 0.

Another easy way to perform instant and/or automated backups of MySQL

PhpMyAdmin is great for what it does but it does not excel everywhere. If you’re looking to create instant or automated backups of MySQL databases consider Sypex Dumper 2.x

Built with PHP, it has an Ajaxed interface and can run database restores as well. Handily it can avoid PHP script timeouts by pausing the jobs. And being licensed under the BSD license, it is absolutely free. Interestingly supposedly it can also be integrated into third-party products… Something I have not done or tried. What impressed me mostly about it was how easy interacting with databases via the browser became with it.

http://sypex.net/en/

Cause and Effect: An example of DR strategy

Voyager 2 left Earth on Aug. 20, 1977 to explore Jupiter and Saturn. It successfully finished that mission, then proceeded to fly on by Uranus and Neptune before heading into interstellar space.
It is currently traveling through heliopause — a region of space where the sun’s influence ebbs and interstellar forces begin to dominate. A rather interesting, and commonly unknown by the general public, portion of our solar system. Think of it a bit like a bow wave from a ship except the material replacing the sea is space/time and the ships hull is the bubble of our solar system.
Voyager 2 and its twin, Voyager 1, are both expected to enter interstellar space — the first human-made objects to do so — in the next five years which means scientists are very excited about what may be discovered in the next five years as both Voyagers push their way through the heliopause. So you can imagine their consternation when it started acting a bit like VGER from Star Trek The Motion Picture
The 33 year old piece of hardware starting speaking in tongues from 8.6 billion miles away preventing mission control from decoding any of its data. Over the course of two weeks with 26 hour round trip communication cycles and replication with exact hardware copies on Earth, the root cause of the problem was discovered to be a single memory bit that had flipped from 0 to 1. A single bit of memory caused the whole system to fail. A simple cause. The effect was catastrophic in impact but NASA did what they do best and implemented predefined processes which included troubleshooting on hardware duplicates and predefined steps through what if scenarios. They were successful. They intend to reset Voyagers memory tomorrow ~ May 20 2010.
The point to take from all of this is – no matter what system you implement you have to have a strategy for handling situations when ‘it’ does not work properly. SharePoint is a difficult product to work in depth with, and when things go wrong they are either minor or very major. But even if you’re working with something other than SharePoint have your DR strategy and related documents ready. Know, comment, and if appropriate visualize with UML, your processes and make sure that others can and will be able to understand what they say. If you do it right, even after 33 years, you can look like a superstar…
If you are interested in more information about the two Voyagers NASA has a weekly update here where you can see detail down to how much propellant the two craft have recently used and left.

PROPELLANT/POWER CONSUMABLES STATUS AS OF THIS REPORT

Spacecraft

Consumption

One Week (Gm)

Propellant

Remaining (Kg)

Output

(Watts)

Margin

(Watts)

1

4.84

26.22

274.2

30

2

4.25

27.90

275.5

29

RANGE, VELOCITY AND ROUND TRIP LIGHT TIME AS OF THIS REPORT

Voyager 1

Voyager 2

Distance from the Sun (Km)

16,915,000,000

13,737,000,000

Distance from the Sun (Mi)

10,510,000,000

8,536,000,000

Distance from the Earth (Km)

16,858,000,000

13,753,000,000

Distance from the Earth (Mi)

10,475,000,000

8,456,000,000

Total Distance Traveled Since Launch (Km)

21,833,000,000

20,860,000,000

Total Distance Traveled Since Launch (Mi)

113,566,000,000

12,962,000,000

Velocity Relative to Sun (Km/sec)

17.071

15.487

Velocity Relative to Sun (Mi/hr)

38,185

34,643

Velocity Relative to Earth (Km/sec)

19.977

22.862

Velocity Relative to Earth (Mi/hr)

44,689

51,139

Round Trip Light Time (hh:mm:ss)

31:13:28

25:28:58