Database Administration Guide - World's Leading Software .

2y ago
47 Views
2 Downloads
2.64 MB
101 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Ronan Garica
Transcription

Database Administration Guide

013008 2008 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in anyform or by any means, electronic, or mechanical, including photocopying, recording, storage in aninformation retrieval system, or otherwise, without the prior written permission of Blackbaud, Inc.The information in this manual has been carefully checked and is believed to be accurate. Blackbaud, Inc.,assumes no responsibility for any inaccuracies, errors, or omissions in this manual. In no event willBlackbaud, Inc., be liable for direct, indirect, special, incidental, or consequential damages resulting fromany defect or omission in this manual, even if advised of the possibility of damages.In the interest of continuing product development, Blackbaud, Inc., reserves the right to make improvementsin this manual and the products it describes at any time, without notice or obligation.All Blackbaud product names appearing herein are trademarks or registered trademarks of Blackbaud, Inc.All other products and company names mentioned herein are trademarks of their respective 3008

DatabaseAdministrationGuideBLACKBAUD MANAGEMENT CONSOLE . . . . . . . . . . . . . . . . . . . 1What is the Blackbaud Management Console? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Using the Blackbaud Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Attaching a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10Creating a New Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22Managing the Deploy Kit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32Migrating a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42Database Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54Active Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57Database Backups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Database Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Server Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93

BlackbaudManagementConsoleContentsWhat is the Blackbaud Management Console . . . . . . . . . . . . . . . . . . . . . . . . . .3Using the Blackbaud Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . .6SQL Server 2005 Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7Blackbaud Management Console Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Database Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9Server Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10Menu Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10Attaching a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10Creating a New Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22Managing the Deploy Kit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32Migrating a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .42Database Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .54Viewing Database Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .26Taking a Database Offline . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55Detaching a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56Active Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57Sending Messages to Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57Disconnecting a User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59Database Backups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .60Scheduling a Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .60Running a Database Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .64Restoring from a Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66Viewing Backup History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68Database Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70Scheduling Database Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70Rebuilding Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .75Updating Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .76Shrinking the Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .78Checking Database Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .79Moving Database Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .81Viewing Maintenance History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .83Server Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86

2CHAPTER 1Starting and Stopping your Database Server . . . . . . . . . . . . . . . . . . . . . . . . . . . 86Managing Server Memory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88Disconnecting from a Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90ProceduresAttaching a Financial Edge, Education Edge, or Blackbaud Student InformationSystem database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Attaching a Raiser’s Edge or Researcher’s Edge database . . . . . . . . . . . . . . . . . 17Creating a new Financial Edge, Education Edge, or Blackbaud Student InformationSystem database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23Creating a new Raiser’s Edge Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Moving the deploy kit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33Repairing the deploy kit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36Changing the default workstation install path. . . . . . . . . . . . . . . . . . . . . . . . . . . 39Migrating a Financial Edge, Education Edge, or Blackbaud Student InformationSystem database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43Migrating a Raiser’s Edge database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Viewing database properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54Taking a database offline . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55Bring a database online . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56Detaching a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57Sending a message to a user . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58Disconnecting a user . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59Scheduling database backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Running a database backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65Restoring from a database backup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Viewing backup history. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68Scheduling database maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Rebuilding indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75Updating statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77Shrinking the database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78Checking database integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80Moving database files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81Viewing maintenance history . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84Starting and stopping your database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87Adjusting server memory use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88Disconnecting from a server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90

BLACKBAUD MANAGEMENT CONSOLE3Welcome to the Database Administration Guide. This guide was written to helpyou successfully use the Blackbaud Management Console. The BlackbaudManagement Console houses database maintenance utilities that help you bettermanage your database. From the Blackbaud Management Console, you can alsostart and stop your server and view important server information.For example, using the Blackbaud Management Console, you can run backups,create new databases, disconnect users, and change deploy kit settings. All thefunctionality of the Blackbaud Management Console is discussed in this guide.What is the BlackbaudManagement Console?The Blackbaud Management Console helps you manage your database. Themanagement console includes links to several database-maintenance wizards andutilities. The following section offers a brief overview of all the wizards andutilities available.Active Users. The Active users category, available in the Installed productspane tree view of the Blackbaud Management Console screen, includesseveral utilities. You can view active users in your database, send messages toactive users, and disconnect active users. Viewing active users: In the Active Users pane, a list of all workstationusers currently working in your database(s) appears. For detailedinstructions about how to view users active in your database(s), see“Active Users” on page 57. Send a message to active users: In the Active Users pane, click Messageto send messages to all or selected database users. For detailed instructionsabout how to send a message to active users, see “Sending Messages toUsers” on page 57. Disconnect active users: In the Active Users pane, click Disconnect todisconnect all or selected database users. For detailed instructions abouthow to disconnect an active user, see “Disconnecting a User” on page 59.Attach Database. If you have an existing Microsoft SQL Server database youuse with your Blackbaud products, you can attach the database to your server.Even if you run a full version of SQL Server 2000 Standard or Enterprise, youmust use the Blackbaud Management Console to attach databases. If you donot use the Blackbaud Management Console, you cannot access the databasesfrom The Raiser’s Edge, The Education Edge, The Financial Edge,Blackbaud Student Information System, or The Researcher’s Edge.For detailed instructions about how to attach a database, see “Attaching aDatabase” on page 10.Backup. The Backup category, available in the Installed products pane treeview of the Blackbaud Management Console screen, includes several utilities.You can schedule a backup of your database to run regularly at a specific time,run a backup of your database(s), or restore your database from a backup file.Information in thisguide is subject tochange. Please visit ourwebsite atwww.blackbaud.com toview the most currentinformation. To access oursystem recommendations,select SystemRecommendations from theSupport menu on ourwebsite.For Read-OnlyDatabase Assistance(formerly RE:Open) users,Microsoft SQL ServerStandard/Enterpriseprovides read and writeaccess to the database. If auser writes a MicrosoftAccess database connectedto The Raiser’s Edge orThe Financial Edgeconnected through the SQLServer database and deletesa record in the Accessdatabase, that record isdeleted inThe Raiser’s Edge orThe Financial Edge. Werecommend you useread-only access. If youwrite to the database, youwill corrupt the data andinvalidate your support andmaintenance agreement.

4CHAPTER 1 Perform Backup: When you click Backup in the Perform Backupframe, you can run a full or compressed backup of your database whileusers continue working in the program. The full backup saves a completecopy of your database in a directory you specify. The compressed backupcompresses your database files into a single Zip file and deletes the copies.For detailed instructions about how to back up a database, see “Running aDatabase Backup” on page 64. Restore from Backup: The Blackbaud Management Console makesrestoring your database from a backup simple. If you use the BlackbaudManagement Console to generate your backup file, click Restore in theRestore from Backup frame and complete a few easy steps. This processworks with full and compressed backups. For detailed instructions abouthow to restore a database from a backup, see “Restoring from a Backup”on page 66. Schedule Backup: When you click Schedule in the Schedule Backupframe, you can establish when your database is automatically backed up.You select the days of the week and time you want the backup to run. Fordetailed instructions about how to schedule a backup, see “Scheduling aBackup” on page 60.Bring database name online. After you take a database offline, you mayneed to bring it back online at a later date. With the Blackbaud ManagementConsole, you can do this easily. For detailed instructions about how to bring adatabase online, see “Bring a Database Online” on page 55Create New Database. Users of The Raiser’s Edge, The Financial Edge, TheEducation Edge, and Blackbaud Student Information System who are newto Blackbaud software or purchase additional databases must use the CreateNew Database Wizard to create a database to use with the program. Fordetailed instructions about how to create a new database, see “Creating a NewDatabase” on page 22.Detach database name . The Detach database name utility, accessedfrom the right-click and Tools menu, enables you to disconnect the databasecurrently connected to the program. You can use the Attach Database Wizard,also available in the Blackbaud Management Console, to attach any otherdatabase in which you want to work. For detailed instructions about how todetach a database, see “Detaching a Database” on page 56.If you are an existingRaiser’s Edge orFinancial Edge user andupdate to a newer version ofthe software, we recommendyou refer to the Raiser’sEdge Update Guide or theFinancial Edge UpdateGuide included with thesoftware package when youupdate the program. Theinformation included in theDatabase AdministrationGuide is geared towarddatabase maintenance, notthe updating process.Maintenance. The Maintenance category, available in the tree view of theInstalled products pane in the Blackbaud Management Console screen,includes several utilities. Schedule Maintenance: Using the Blackbaud Management Console, youcan schedule various database maintenance options to run at specificintervals. For example, you can select to automatically rebuild yourdatabase indexes at 12 a.m. every Saturday. For detailed instructions abouthow to schedule database maintenance, see “Scheduling DatabaseMaintenance” on page 70. Rebuild Indexes: Using the Blackbaud Management Console, you canrebuild database indexes to reorganize the storage of the index data andremove fragmentation. For detailed instructions about how to rebuilddatabase indexes, see “Rebuilding Indexes” on page 75.

BLACKBAUD MANAGEMENT CONSOLE5 Update Statistics: Using the Blackbaud Management Console, you canupdate optimizer statistics. This process optimizes database performanceby recalculating information about the organization of key values inindexes used by the database engine. For detailed instructions about howto update optimizer statistics, see “Updating Statistics” on page 76. Shrink Database: Using the Blackbaud Management Console, you canshrink your database to reclaim vacated space. For detailed instructionsabout how to shrink the database, see “Shrinking the Database” onpage 78. Check Integrity: Using the Blackbaud Management Console, you can runa validation to check database integrity. We recommend you run thisutility before you make changes to your system, such as upgradinghardware or software. For detailed instructions about how to check thedatabase integrity, see “Checking Database Integrity” on page 79.Manage Deploy Kit. Users of The Raiser’s Edge, The Financial Edge, TheEducation Edge, and Blackbaud Student Information System can use theDeploy Kit Wizard, available from the Manage Deploy Kit frame on theBlackbaud Management Console screen, to create, update, and move thedeployment kit used by your workstations to access the program. For detailedinstructions about how to manage the deploy kit, see “Managing the DeployKit” on page 32.Migrate Database. Users of The Raiser’s Edge, The Financial Edge,The Education Edge, and Blackbaud Student Information System can usethe Blackbaud Management Console to migrate existing Blackbaud ASAdatabases into Microsoft SQL Server. For detailed instructions about how tomigrate a database, see “Migrating a Database” on page 42.Servers. Using the Blackbaud Management Console, you can stop, start, andpause your server; disconnect from your server; and manage server memoryuse. Stop/Start/Pause Database: Using the Blackbaud Management Console,you can start and stop your database server. When you stop a database,users cannot log in. For detailed instructions about how to start, stop, andpause your server, see “Starting, Stopping, and Pausing your DatabaseServer” on page 86. Disconnect from server name : To access a Microsoft SQL Server, theBlackbaud Management Console must first establish a connection to theserver. This connection is established automatically when you run theinstallation or update. Afterward, you can disconnect the BlackbaudManagement Console from a server without affecting user access to thedata. For detailed instructions about how to disconnect from a server, see“Disconnecting from a Server” on page 90. Manage Server Memory Use: Using the Blackbaud Management Console,you can configure server memory use. We recommend only experiencedsystem administrator’s or certified SQL Server technicians adjust theserver memory settings. For detailed instructions about how to manageserver memory, see “Managing Server Memory” on page 88.To use Crystal Reportsto run reports directlyoff a SQL Server databaserunning SQL ServerStandard, SQL ServerEnterprise, or MSDE withRead-Only DatabaseAssistance, a CrystalReports Professional licenseis required. For informationabout purchasing CrystalReports Professionallicenses, contact youraccount representative orsend an email request tosolutions@blackbaud.com.

6CHAPTER 1Take database name offline. Using the Blackbaud Management Console,you can take a database offline. This means the database is closed, markedoffline, and cannot be modified. When you bring the database back online, thedatabase is open and available for use. Online is the default setting. Fordetailed instructions about how to take a database offline, see “Taking aDatabase Offline” on page 55.Using the BlackbaudManagement ConsoleIf you have version 7.5or earlier ofThe Raiser’s Edge installed,you will have twoBlackbaud ManagementConsoles on the server afteryou install The FinancialEdge.Once you install The Financial Edge, The Education Edge, The Raiser’s Edge,Blackbaud Student Information System, or The Researcher’s Edge, you canaccess the Blackbaud Management Console by clicking the shortcut located onyour desktop.The Blackbaud Management Console screen appears.The main screen of the Blackbaud Management Console contains two panes. Onthe left, the Installed products pane uses a tree view representation to display theprograms you have installed, database(s) for each program, and server(s) runningthe programs.

BLACKBAUD MANAGEMENT CONSOLEThe information in the pane on the right depends on your selection in theInstalled products pane. For example, if you select The Financial Edge,The Education Edge, Blackbaud Student Information System, The Raiser’sEdge, or The Researcher’s Edge in the Installed products pane, the databasewizards appear. If you select Servers in the Installed products pane, serverinformation appears.To expand and display all the database and server information in the tree view,click the plus signs ( ) in the Installed products pane. To hide the database andserver information in the tree view, click the minus signs (-) in the Installedproducts pane.There are multiple ways to access the functionality housed in the BlackbaudManagement Console. To access the database wizards, selectThe Financial Edge, The Education Edge, Blackbaud Student InformationSystem, The Raiser’s Edge, or The Researcher’s Edge in the Installed productspane, or click the Wizards link in the right pane. You can also use the Tools menuto access the database wizards.To navigate through the Blackbaud Management Console, use the Back andForward buttons located on the toolbarSQL Server 2005 RequirementsIf you use SQL Server 2005 with the Blackbaud Management Console, you mustdo as follows: To each Microsoft Windows user or user group that accessesThe Raiser's Edge, a SQL Server 2005 administrator using Windows OnlyAuthentication must apply the “View Server State” permission. On the machine running the Blackbaud Management Console, install SQLServer 2005 client tools.7You can access theBlackbaudManagement Console helpfile from the Help menu.

8CHAPTER 1Blackbaud Management Console WizardsThe programs you haveinstalled appear in theInstalled products pane.To access the various Blackbaud Management Console wizards available, select aproduct in Installed products pane, locate the wizard to run in the right pane, andclick Run Now. This guide includes detailed instructions on how to work in allwizards available in the Blackbaud Management Console.If you have thestandalone version ofThe Raiser’s Edge installed,only the Attach Database,Create New Database, andMigrate Database wizardsappear on the BlackbaudManagement screen.For a definition of each wizard, see “What is the Blackbaud ManagementConsole?” on page 3.

BLACKBAUD MANAGEMENT CONSOLE9Database UtilitiesMost of the database utilities are accessed through the Installed products panetree view under the database name.Additional database utilities are housed in the Tools or right-click menu. For adefinition of each database utility, see “What is the Blackbaud ManagementConsole?” on page 3.If you have thestandalone version ofThe Raiser’s Edge installed,only the Attach Database,Create New Database, andMigrate Database wizardsappear on the BlackbaudManagement screen.

10CHAPTER 1Server UtilitiesTo access the server utilities, click the Servers category in the Installed productspane tree view. The utilities appear in the right pane.Additional server utilities are housed in the Tools menu or right-click menu. For adefinition of each server utility, see “What is the Blackbaud ManagementConsole?” on page 3.Menu CommandsThe Blackbaud Management Console contains three menus. You use these menucommands on the toolbar to access Blackbaud Management Consolefunctionality. The Tools menu is active only for certain functionality.Action. From the Action menu, you exit the Blackbaud Management Console atany time.Tools. From the Tools menu, you access a number of database tools andmaintenance functionality, as well as database user information. The optionson the Tools menu vary depending on your selection in the Installedproducts pane.Help. From the Help menu, you access the Blackbaud Management Console helpfile and Blackbaud Management Console program information.Attaching a DatabaseIf you have an existing Blackbaud Microsoft SQL Server database, you use theAttach Database Wizard to attach it to the Blackbaud Management Console. Thisfeature is useful if you move or detach a database.

BLACKBAUD MANAGEMENT CONSOLEThe Attach Database Wizard, which guides you through the process step by step,varies slightly based on the Blackbaud product you use.¾Attaching a Financial Edge, Education Edge, or Blackbaud StudentInformation System database11The Attach DatabaseWizard is only forattaching a database that hasalready migrated to SQLServer.The screens depicted in this procedure appear for users of The FinancialEdge. If you use The Education Edge or Blackbaud Student InformationSystem, the screens display information specific to The Education Edge orBlackbaud Student Information System.1. From the Installed products tree view, select The Financial Edge. Theprogram wizards appear in the pane on the right of the screen.Even if you run a fullversion of SQL Server2000 Standard orEnterprise, you must use theBlackbaud ManagementConsole to attach databases.If you do not use theBlackbaud ManagementConsole, you cannot accessthe databases fromThe Raiser’s Edge,The Education Edge,The Financial Edge,Blackbaud StudentInformation System, orThe Researcher’s Edge.

12CHAPTER 1To run the wizard, youcan also click the iconsthat appear in the wizardframes or use the Toolsmenu.2. In the Attach Database frame, click Run Now. The welcome screen forthe Attach Database Wizard appears.3. If you use the MSDE version of SQL Server, proceed to step 4. Otherwise,proceed to step 6.4. Click Next. The Select Server screen appears.

BLACKBAUD MANAGEMENT CONSOLE5. Select the server instance to use. To use the FE7 MSDE server instance, mark Use The Financial Edgedatabase server and proceed to step 11. To use a server other than the FE7 MSDE instance, mark Selectanother SQL Server instance and proceed to step 6.13Due to MSDE sizerestrictions, if yourdatabase is larger than 1.8gigs, mark Select anotherSQL Server instance.6. Click Next. The Server Information screen appears.7. In the Select Server field, select the server to which to attach thedatabase. To display the available servers, click Available.8. In the Login information frame, select the type of authentication to use. To use your own version of SQL Server with Windows authentication,mark Use Windows authentication. To use Microsoft SQL Server authentication, mark Use SQL Serverauthentication.9. If you mark Use SQL Server authentication, enter a Login name andPassword for the server. If the MSDE version is selected, the name andpassword are entered automatically.10. To check the database connection, click Test. If the database connectionfails, check the login information and verify you selected the correctserver.If you are not using theMSDE version of SQLServer included withThe Financial Edge andyour server is setup forWindow Authenticationonly, you must use the SQLEnterprise Manager to addusers to The FinancialEdge. For more information,see the documentationincluded with your SQLServer software.

14CHAPTER 111. Click Next. The Database Information screen appears.12. In the Attach field, select the type of database to attach. To attach an existing database, mark Existing database (MDF file). To attach a backup of a database, mark From backup file (BAK orZIP file).Depending on the option you select, the fields in the Parameters framechange.13. In the Path to existing database or Path to backup database field, enterthe path to the database to attach. To locate the database, click the browsebutton.14. In the Name for existing database or Name for restored database field,enter a database name. This name appears on the server.15. In the Description for existing database or Description for restoreddatabase field, enter a description of the database. The description youenter appears when you log into the program. For example, if this issample data you use for in-house training, enter that information here.16. If you have changed the default location of your existing database, clickthe To adjust file location(s) or To adjust file destination(s) link abovethe Path to existing database or Path to backup database field. TheDatabase Information screen appears.

BLACKBAUD MANAGEMENT CONSOLE15To specify the current location of the database, double-click the file andclick Return to the previous screen. You return to the DatabaseInformation screen.17. Click Next and proceed to step 18 unless you are attaching a FinancialEdge database to a SQL Server 2005 instance.When attaching a Financial Edge database, a warning message appears ifyou attempt to attach a SQL Server 2000 database to a SQL Serve

database online, see “Bring a Database Online” on page 55 Create New Database. Users of The Raiser’s Edge, The Financial Edge, The Education Edge, and Blackbaud Student Information System who are new to Blackbaud software or purchase additional databases must use the Create New Database Wizard to create a database to use with the program. For

Related Documents:

Database Applications and SQL 12 The DBMS 15 The Database 16 Personal Versus Enterprise-Class Database Systems 18 What Is Microsoft Access? 18 What Is an Enterprise-Class Database System? 19 Database Design 21 Database Design from Existing Data 21 Database Design for New Systems Development 23 Database Redesign 23

Getting Started with Database Classic Cloud Service. About Oracle Database Classic Cloud Service1-1. About Database Classic Cloud Service Database Deployments1-2. Oracle Database Software Release1-3. Oracle Database Software Edition1-3. Oracle Database Type1-4. Computing Power1-5. Database Storage1-5. Automatic Backup Configuration1-6

real world about which data is stored in a database. Database Management System (DBMS): A collection of programs to facilitate the creation and maintenance of a database. Database System DBMS Database A database system contains information about a particular enterprise. A database system provides an environment that is both

The term database is correctly applied to the data and their supporting data structures, and not to the database management system. The database along with DBMS is collectively called Database System. A Cloud Database is a database that typically runs on a Cloud Computing platform, such as Windows Azure, Amazon EC2, GoGrid and Rackspace.

Creating a new database To create a new database, choose File New Database from the menu bar, or click the arrow next to the New icon on the Standard toolbar and select Database from the drop-down menu. Both methods open the Database Wizard. On the first page of the Database Wizard, select Create a new database and then click Next. The second page has two questions.

viii Related Documentation The platform-specific documentation for Oracle Database 10g products includes the following manuals: Oracle Database - Oracle Database Release Notes for Linux Itanium - Oracle Database Installation Guide for Linux Itanium - Oracle Database Quick Installation Guide for Linux Itanium - Oracle Database Oracle Clusterware and Oracle Real Application Clusters

By becoming a certified Oracle Database Administrator Professional, you demonstrate the full skill set needed to perform day to day administration of the Oracle Database. Preparing to take the Oracle Database certification exam broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks.

take the lead in rebuilding the criminal legal system so that it is smaller, safer, less puni-tive, and more humane. The People’s Justice Guarantee has three main components: 1. To make America more free by dra-matically reducing jail and prison populations 2. To make America more equal by elim-inating wealth-based discrimination and corporate profiteering 3. To make America more secure by .