• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Maintaining Data Reporting a... > Maintaining SQL Server 2000 Database...

Maintaining SQL Server 2000 Databases

Microsoft SQL Server 2000 provides two tools, Enterprise Manager and Query Analyzer, that make basic database maintenance a snap. Both tools have graphical user interfaces that make working with databases much simpler.

To use Enterprise Manager on a computer with SQL Server 2000 installed, on the Start menu, click Programs, click Microsoft SQL Server, and then click Enterprise Manager. Once Enterprise Manager appears, you can access the database you want to maintain by opening the Console Root folder and then expanding the Microsoft SQL Servers group, the SQL Server group containing your database server, and the database server, as shown in Figure 12-1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint