Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sleonard24
Starting Member
5 Posts |
 Posted - 2010-12-01 : 15:53:43
|
| I'm just getting started with MS SQL databases and managing them. I currently have a SQL 2005 64-bit server with SQL Management Studio Express installed. I want to upgrade Management Studio Express to the full SQL Management Studio. I am doing this as I want to be able to use the Maintenance Wizard of the full version.Could anyone give me some instructions/steps/tips on how to go about this process? Any advice is greatly appreciated.Scott |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-01 : 16:50:41
|
| Just choose client tools from the installer |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-12-01 : 17:01:26
|
| Uninstall SQL Management Studio Express - then you will be able to install the standard version. Also, make sure you apply the latest service pack after installing.My other tip, don't use the maintenance plan wizard. Identify what you want to do in the maintenance plan first, then set it up that way. For example, you probably want to start with a basic plan that has the following steps:1) Integrity Checks2) Backup Databases3) Remove Old Backup Files (Maintenance Cleanup Task)Add a Notify Operator task to the plan and connect it to each of the above tasks on failure. Modify the dependency and change it from AND to OR so you get a red dashed line. This will make sure you get a notification if any one of the tasks fail.Once you have a basic plan setup, you can determine whether or not you need to add additional tasks. In most cases, you can just create a weekly scheduled task to rebuild or reorganize indexes (either one, not both) and update statistics.Jeff |
|
|
|
sleonard24
Starting Member
5 Posts |
Posted - 2010-12-02 : 09:19:55
|
| Jeff and Russell:Thank you for the above tips/information. I'll test it and report back any results.Scott |
|
|
|
sleonard24
Starting Member
5 Posts |
Posted - 2010-12-07 : 12:52:54
|
| After testing and deploying into production, all seems to be working. Thank you for the help and advice.Scott |
|
|
|
|
|
|
upgrade management studio version