SQL 2000 Maintenance > Small Business Server Support Forum

ForumsSurveysChat

Support

Forum

Download

About

Registered users

	Membership:
	Latest:Taganova Ronya
	New Today:12
	New Yesterday:9
	Overall:23415

Private messaging

You must be logged in to use this module.

Top 10 posters

Name	Posts
Mariette Knap	12968
Marina Roos	12627
Eriq Neale	2117
Stan Guinn	1917
Michael Patrick	1914
Robert Pearman	1791
Nick Pieters	1425
william warren	650
Stewart Brown	620
Kevin D.	579

Articles

»	Antivirus
»	Backup and restore
»	BlackBerry
»	Branch offices
»	Configuring routers
»	CRM
»	Exchange Server 2000
»	Exchange Server 2003
»	Exchange Server 2007
»	ISA Server 2000
»	ISA Server 2004
»	Macintosh integration
»	Network configuration
»	Planning and installing your SBS server
»	Press releases
»	Project server
»	Public articles
»	Remote Access
»	SBS 2000
»	SBS 2003
»	SBS 2003 R2
»	SBS 2008
»	Securing your SBS 2003 network
»	Server issues
»	Service Packs
»	Sharepoint
»	SQL 2000
»	SQL 2005
»	SQL 2008
»	Subscriber articles
»	Terminal Servers
»	Third party solutions
»	Windows SBS 2003 to 2008 Migration Guide
»	Workstations

View all articles

Welcome unauthorized visitor

If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.

Small Business Server Support Forum

Unanswered Active Topics

Forums Search

Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000

Subject: SQL 2000 Maintenance

Prev Next

You are not authorized to post a reply.

Author

Messages

Tony R

United States
Member since
6/30/2005

Platinum Membership
Posts: 68

7/10/2008 10:19 PM
hi all, I have an installation of SBS2003 Prem w/SP1. Sharepoint instance has been upgraded to SQL 2000. Is there a maintenance plan that has to be run on sql 2000 in SBS? Is there a wizard for this or is this something that has to be done manually or not at all? Thanks TR

Edwin Sarmiento User is Offline

Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133

7/18/2008 08:53 AM
I don't quite understand by what you mean by maintenance but if that means database maintenance, you can do so by right-clicking the database Maintenance Plan node inside the Management folder in SQL Server Enterprise Manager. Select New Maintenance Plan and this will fire up a wizard to create a database maintenance plan that will allow you to reorganize index pages, backup the databases, etc.

MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA http://bassplayerdoc.blogspot.com Need a remote SQL Server DBA?

You are not authorized to post a reply.

Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > SQL 2000 Maintenance

ActiveForums 3.7

Forum policy

These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:

No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving/removing a thread or post or comment.