Express Studio doesn't automate backups though. You can back up but you can't schedule it like with the 'full' studio. You can install from the SQL Server disks. That's what I did when I had to set up the studio on a couple of pc's. To: [email protected] Subject: RE: SQL Server 2005 management suite From: [email protected] Date: Wed, 28 Apr 2010 12:58:04 -0500
Thanks! I didn't notice that last part.. "SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005." -- RMc Jay Dale <[email protected]> wrote on 04/28/2010 12:31:04 PM: > Is this what you need? > > http://www.microsoft.com/downloads/details.aspx? > displaylang=en&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796 > > > Jay Dale > I.T. Manager, 3GiG > Mobile: 713.299.2541 > Email: [email protected] > > Confidentiality Notice: This e-mail, including any attached files, > may contain confidential and/or privileged information for the sole > use of the intended recipient. If you are not the intended > recipient, you are hereby notified that any review, dissemination or > copying of this e-mail and attachments, if any, or the information > contained herein, is strictly prohibited. If you are not the > intended recipient (or authorized to receive information for the > intended recipient), please contact the sender by reply e-mail and > delete all copies of this message. > > > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, April 28, 2010 11:40 AM > To: NT System Admin Issues > Subject: SQL Server 2005 management suite > > > Greetings! > > I have a server (Win 2003) with MS SQL Server 2005 (not "Express") > on it as a part of my VMWare management system. I need to back up > this database. It does _not_ have the "Management Suite" installed. > I do not believe I have the license key for that installation, either. > > I happen to have a set of SQL Server disks (2 CD, 1 DVD, one "MS > Library" CD). I also have the download for SQL Server 2005 Express > Management Suite. > > What is the least bad way to get MS management (again, just for DB > backup) onto this machine? > > I figure the "Express" version will not work with "Full" SQL Server, right? > > If I were to use one of the "Full" setup disks and run "Setup", > would I have the option of modifying (ie, adding Mangement Suite) to > the current install and existing database? Is this reasonably safe to do? > > I've obviously never before run SQL Server setup before - thanks! > -- > Richard D. McClary > Systems Administrator, Information Technology Group > ASPCA® > 1717 S. Philo Rd, Ste 36 > Urbana, IL 61802 > > [email protected] > > P: 217-337-9761 > C: 217-417-1182 > F: 217-337-9761 > www.aspca.org > > The information contained in this e-mail, and any attachments > hereto, is from The American Society for the Prevention of Cruelty to Animals® > (ASPCA®) and is intended only for use by the addressee(s) named > herein and may contain legally privileged and/or confidential > information. If you are not the intended recipient of this e-mail, > you are hereby notified that any dissemination, distribution, > copying or use of the contents of this e-mail, and any attachments > hereto, is strictly prohibited. If you have received this e-mail in > error, please immediately notify me by reply email and permanently > delete the original and any copy of this e-mail and any printout thereof. > > > > > _________________________________________________________________ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1 ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
