SQL Server 2005 Management Studio (when subscribed to the Action Pack) is located on disk 2.

I was worried about disrupting an active install of SQL server and wasn’t sure where the installation file was for the management studio on the disk.

Many other blogs, help files, and forums said to look in a Tools folder of the installation disk.  No such luck for me.  The company I’m working at is subscribed to the Action Pack which is why, I’m guessing, the disks were a bit different.  No tools folder.

If you’re subscribed to the Action Pack, there is a two disk set.  Simply pop in disk 2.  You won’t see an individual installation file for the management studio, but no worries.  The setup program will let you choose which components you wish to install.

It’s likely that when someone was installing your SQL Server that they didn’t bother with the second disk.  If you’re looking to add a new Maintenance Option (for say, making automated backups), Management Studio Express isn’t going to help you.  When you right click, the only option you get is ‘refresh’.

After installing the real mccoy (and starting the Agent XP service by right-clicking on it), the New Maintenance Option was available when selecting the Maintenance Plans folder in the object explorer.ex

Hooray for the full version of Management Studio and automated daily backups.

And also a big thank you for the backup scripts located here: http://www.sql-server-performance.com/2007/creating-backup-jobs/