|
In this topic: |
Master Login
A Master Login can use the Databases folder to archive old STORAGE Databases, making room for new ones. A STORAGE database can be archived as soon as it reaches its maximum size and another database has been automatically created. The Jobs Management pane shows the date and status of the last archive of each STORAGE database (from the current SQL Server instance), and you can obtain History for the archive job to view all archives performed on the database.
|
|
Do not attempt to use the Dashboard while an Archive or Restore is taking place. |
An archive
affects only STORAGE data.
Unlike a full
backup, which copies all
data from ALL databases to the backup location, an archive moves only
STORAGE data to the archive location. Archived data is no longer accessible
by Dashboard users. An archive does not include
Admin, Customer or Data Vault databases, which remain active following
an archive.
You
can restore archives.
In order to restore a STORAGE archive, the archived database must be
on the list of databases in Databases Management and it must be on the
database computer. If you've moved the archive off the computer's hard
drive, before attempting to restore, move it back on. The default location
for archives is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Spctr_Archive.
You
can archive only a full STORAGE database.
Spector 360 STORAGE databases have a size limit of 4 GB (4,096 MB)
if SQL Server Express is installed,
and a user-defined limit if SQL Server Standard
is installed. When a database reaches its size limit, Spector 360 automatically
creates a new database (e.g., STORAGE-002). You can archive a database
only after it is full and a new one has been created. Normally the data
is stored sequentially (in order of recording time). You can see exactly
what is in each database by selecting it and clicking View
Statistics on the toolbar.
Archives
write to the database computer.
The default location for archives is on the Data Vault - Database computer
at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Spctr_Archive.
You can direct the Archives to a different location on the SQL Server/Database
computer. SQL Server needs full permission to the archive location, and
the only way to ensure the permission is by using a destination on the
machine where the Spector 360 SQL Server instance resides. When the archive
is complete, you can move it to a different location.
You
can set up automatic archiving.
The Space Management
tool provides options for automatic archiving when certain conditions
are met.
To archive a database:
Select the Management tool and Databases.
In the right pane, select the full STORAGE database you wish to archive . The database must have reached its maximum size and a new database must be started.
Click Archive Database on the toolbar,
or
right-click the STORAGE database and select Archive
Database.
A message appears informing you that the database will be offline (not available) after archiving. Click Yes to continue.
Wait as the operation is performed.
The database is removed to the specified archive location and is no longer
directly accessible. Click Refresh
on the toolbar to make sure that the archived database now reads "Yes"
in the Archived field.
Note that you can still view statistics and history for the archived database. This will be useful if you need to return to data from a particular time period for investigation or research.
About the Archive
