2005 SQL Maintenance

[sbruce66]

Hello All,
I have recently setup a Goldmine server running on VMware with a SQL backend. I keep hearing everyone talk about Enterprise Manager. Does this come with 2005 SQL Workgroup Edition. I have been looking for the download but can't find it.

Also, what maintenance should I perform on SQL.

 

[mrdenny]

In SQL 2005 it's called SQL Server Management Studio. If you installed the Client Tools it will be installed. If you didn't run through the SQL Server installer again and select to install just the client tools.

As for maintenance you'll want to schedule regular backups as well an index rebuilding. This can all be done via a maintenance plan with the GUI once you have access to it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog