Hello and welcome to our Knowledge Base. Our experts provide answers to the most frequently asked questions of our customers. Start your information search here to find your answer quickly and easily.
Please enter your query or select one of the above categories.
All entries (Page 2 / 6)
Of course not. The data is persistent in the database. SpaceObServer will not delete data, it will only update data.
We will take care in V4.2 that the last access date is no longer changed when SpaceObServer calculates the MD5 checksum. Thanks for pointing our attention to this matter.
In the context menu of the Configure Scans dialog (Scan > ConfigureScans) there is an entry "Change Scan Location" in the sub menu "ExpertSettings". Use this option to change the selected directory path, when thedirectory was moved.
To upgrade youSpaceObServer instance to a newer version (no matter if minor or major update),you just have to install the new version over the existing installation.All the user settings andthe connected database will be kept.We recommend installing theSpaceObServer instances before the SpaceObServer Remote Administration Clients. Note: Please ensure that you are using the same versions of SpaceObServer andRemote Administration Clients.
SpaceObServerships with some OLE Automation example scripts, showing most of the automationfunctionality. Please find this scripts in your Windows start menu entry"OLE Automation Examples" (entry "SpaceObServer") or in theinstallation sub directory "demos". For more detailed documentation of the OLE Automation interface, please take alook at the SpaceObServer help file, Section "OLE Automation".
When youmove a file on your hard disk, SpaceObServer will notice this file as newfiles. To show correct size growth in the SpaceObServer "History" wecannot use the reported creation date of the moved files, because in this casethe file will be reported twice in the SpaceObServer "History".
Date time values:
The representation of dates in the SpaceObServer database is equal to the Delphi TDateTime specification. One reason for this is that it is much easier to support different SQL databases.
In Delphi, TDateTime is a type that maps to a Double. In C++, the TDateTime class corresponds to the Delphi TDateTime type. The integral part of a Delphi TDateTime value is the number of days that have passed since 12/30/1899. The fractional part of the TDateTime value is fraction of a 24 hour day that has elapsed. Following are some examples of TDateTime values and their corresponding dates and times:
0 12/30/1899 12:00 am
2.75 1/1/1900 6:00 pm
-1.25 12/29/1899 6:00 am
35065 1/1/1996 12:00 am
To find the fractional number of days between two dates, simply subtract the two values, unless one of the TDateTime values is negative. Similarly, to increment a date and time value by a certain fractional number of days, add the fractional number to the date and time value if the TDateTime value is positive. When working with negative TDateTime values, computations must handle time portion separately. The fractional part reflects the fraction of a 24-hour day without regard to the sign of the TDateTime value. For example, 6:00 am on 12/29/1899 is –1.25, not –1 + 0.25, which would be –0.75. There are no TDateTime values between –1 and 0.
To convert this value to the MS SQL Server data type datetime us the DATEADD() function:
SELECT DATEADD(dd , LASTSCAN_TIME, '18991230 ') FROM ROOTS
SELECT DATEADD(hh , LASTSCAN_TIME*24, '18991230 ') FROM ROOTS
SELECT DATEADD(mi , LASTSCAN_TIME*24*60, '18991230 ') FROM ROOTS
SpaceObServer works well with SQL Server Express and is used by many customers in this combination. The version 2000 - 2008 are supported. We have not tested it with the specific SQL Server express that comes with BackupExec, but I don ' expect any problems. Our trial version allows you test this for free and our support will assist you in case a problem occurs.
You canuse the SpaceObServer OLE Automation interface (See: Help file > section OLE Automation) to automate SpaceObServerexports by your own scripts or executable. You canalso use the "SpaceObserverCmdLineParser.exe" to do this. E.g.:SpaceObServerCmdLineParser.exe/EXTENSIONSLIST "C:\Reprots\C_file_types_share1.csv""\Server1\share1"SpaceObServerCmdLineParser.exe/EXTENSIONSLIST "C:\Reprots\C_file_types_share2.csv""\Server1\share2"...
You canpurge data older than X days within the Configure Scans dialog (Scan >Configure Scans > Scan Options > Archive Size data for X days). You haveto run an update scan after changing this option, or run "SynchronizeDatabase Values" from within the lists context menu (context menu >Expert Settings > Synchronize Database Values).
If you wantto move databases in the same type of SQL servers, it is sufficient to justmove the database from one SQL server to another. Since SpaceObServer V4 you can do this automatically, and independent of SQLserver types, by using the "Export to SQL Server" function (Scan >Configures Scans > Right click on the scans to exports > Export>Export to SQL Server).
One reason for this could be that your account does not have access rights to the MS SQL server. Even if this is your administrator account, this does not automatically mean that this account has access rights to the MS SQL server. Another possible reason could be that the MS SQL server was not configured to allow remote access or allow access via Windows authentication.Both can be configured in your SQL Management Studio.