Posts Tagged by Exercises

exercise – move system databases

24-Aug-2006 Posted by Sonia Hamilton under , ,
No Comments

In this exerise, you are required to move two of the system databases (master and model) to c:data. Here are some web pages that may help:

Steps:

  1. move master
    • change the startup properties for the server, to point to a different location for master
    • stop the server using Administrative Tools, Services
    • manually move master’s database files using Windows Explorer to c:data
    • start the server using Administrative Tools, Services
    • in Enterprise Manager, check the properties of the master database, to ensure that master is running from the new location (more…)

multiserver jobs exercise

14-Dec-2005 Posted by Sonia Hamilton under ,
No Comments

Exercise

  1. Have a second instance of SQL Server running, either by:
    • installing a second instance of SQL Server
    • starting up a second Virtual PC
  2. If using Virtual PC’s, check that you have network connectivity between both VPC’s:

sql 2000 administration exercise

09-Nov-2005 Posted by Sonia Hamilton under , ,
No Comments

Scenario

A complete install of a Microsoft Sql 2000 Server instance, and the creation of some additional objects.

Members

Work in groups of three. One member of each team will be nominated as the TEAM LEADER who will co-ordinate job responsibilities with the rest of the group. (more…)