Filter
Top Products
Administering Database Restoring a Database to a Different PC
INDeX Contact Centre Modules Page 88
Installation & Maintenance 38HBK00001SCM - Issue 11 (05/01)
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: