-
Title
xp_backup_database return/output message and Run Code -
Description
Output message displayed when Litespeed xp_backup_database extended stored procedure is executed in SQL Server Management Studio (SSMS) or Query Analyzer usually varies depending on whether you are using a commercial version or demo/evaluation version.
-
Resolution
Message displayed by evaluation version is similar to the below;
Msg 1, Level 1, State 1
Evaluation Edition: 14 days left
LiteSpeed 2005 Version 4.5.0.00182
Copyright (C) 2004-2006, Imceda Software Inc. All Rights Reserved.
www.imceda.com.
Registered Name: Evaluation Edition: 14 days left
Processed 336 pages for database 'Database', file 'Database' on file 1.
Processed 1 pages for database 'Database', file 'Database_log' on file 1.
BACKUP DATABASE successfully processed 337 pages in 0.182 seconds (15.129 MB/sec).
This SQL Litespeed backup has saved you approximately 3 MB of space.
This computes to a total hardware and tape media savings of $2.16 for this usage with an annual savings of $51.84.
For a more detailed ROI calculation including cost of personnel,
savings in recovery time and hardware performance savings go to http://www.imceda.com/ROI/.
(Calculations use average disk and storage managements cost per Gartner and IDC.)
Run code : VABTAEgASQBSAFQAOgA3ADMAOgAwACgATQBCACkAOgAyADgAOgAwADMAOgAyADMAA2ACAAMQA0ADoAMwA
Backup added as file number: 1
Native Size: 5.31 MB
Backup Size: 0.61 MB
CPU Seconds: 0.25
Environment: Intel(R) Pentium(R) 4 CPU 3.20GHz
CPUs: 2 logical, 1 core, 1 physical package.
Message displayed for Licensed Version will not include "Run Code". Run code consists of messages on Litespeed backup savings made with regards to disk space, growth and costs used by the Sales Department and only display when LiteSpeed is running in Demo Mode.
Message for licensed version will be similar to the below;
LiteSpeed for SQL Server(TM) Version 5.0.2.1030
Copyright (C) 2004-2008, Quest Software Inc. All Rights Reserved.2004-2008, Quest Software Inc. All Rights Reserved.
Quest Software.
Registered Name: Quest software
Processed 952 pages for database 'msdb', file 'Database' on file 1.
Processed 5 pages for database 'msdb', file 'Database' on file 1.
BACKUP DATABASE successfully processed 957 pages in 0.966 seconds (8.111 MB/sec).
Backup added as file number: 1
Native Size: 9.63 MB
Backup Size: 1.90 MB
CPU Seconds: 0.52
Environment: Intel(R) Pentium(R) 4 CPU 3.00GHz
CPUs: 2 logical, 1 core, 1 physical package.