Avaya 38HBK00001SCM manual Restoring a Database to a Different PC, Expand a Database

Administering Database Restoring a Database to a Different PC

Restoring a Database to a Different PC

This is to help those who are attempting to restore a previously backed up database onto a different machine. The following steps should be completed from the new machine within SQL Enterprise Manager after you have restored the database.

3.Within Enterprise Manager expand the Security folder.

4.Click on Logins and then Right mouse click on the SDXArchiver and select properties.

5.Click on the Database Access Tab.

6.Tick the box next to SDXArchiver. Whilst this is highlighted ensure that the two boxes 'PUBLIC' and ’DB_OWNER' are checked in the lower half of the window.

7.Tick the box next to SDXrepository. Whilst this is highlighted ensure that the two boxes 'PUBLIC' and ’DB_OWNER' are checked in the lower half of the window

8.Close the properties window, exit SQL Enterprise Manager.

Expand a Database

Microsoft® SQL Server™ can expand a database automatically, according to growth parameters defined when the database was created. However this feature is disabled during the installation of the INDeX Report Manager. You can manually expand the SDXARCHIVER database by allocating additional file space on an existing database file

When expanding a database, you must increase the size of the database by at least 1 megabyte (MB). When a database is expanded, the new space is made immediately available to the data file.

During the INDeX Report Manager installation, 2GB database is created on the D:\ drive. It is advisable to increase the size of the database as follows:

–For SPC5 expand the database to: 5GB

–For SPC10 expand the database to: 20GB

–For SPC20 expand the database to: 41GB

When the database is 80% full you will be presented by a Free space Disk warning. Once it gets to 95% another message is displayed warning you that it will start clearing the oldest day’s data.

This section details the procedure required to expand the SDXArchiver database.

1.From the Windows NT Taskbar, click the Start button, point to Programs and Microsoft SQL Server 7.0 and then select Enterprise Manager.

2.Expand the Server group (i.e. SQL Server Group), expand the Server (i.e. ARCHIVERSQL) and then the Databases, as displayed in the screen on the following page:

INDeX Contact Centre Modules	Page 88
Installation & Maintenance	38HBK00001SCM - Issue 11 (05/01)