Menu

#10 MSSQLCompressedBackup

open
nobody
None
5
2011-03-10
2011-03-10
Freddy
No

I am trying to compress a backup Database. All the work I do is remotely, I have the tool MSSQL Compressed Backup (to be exact is MSSQLCompressedBackup-1.2-20100527) on this remotely server; This is the server where we have all the backups. I do not have any SQL server platform install. Since this is my first time using this tool, I am not even sure I wrote it right. Anyhow, I wrote the command, but this happened:

Could not create an instance: CLSID_MSSQL_ClientVirtualDeviceSet, x80040154

System.InvalidProgramException

C:\Documents and Settings\Administrator>cd C:\Documents and Settings\Administrat
or\Desktop\MSSQLCompressedBackup-1.2-20100527\MSSQLCompressedBackup-1.2-20100527
_x86

C:\Documents and Settings\Administrator\Desktop\MSSQLCompressedBackup-1.2-201005
27\MSSQLCompressedBackup-1.2-20100527_x86>msbp.exe backup "db(database=EMS_Backu
p_T1.bak)" "gzip" "local(path=C:\Backup\EMS_Backup_T1.bak.)"
Could not create an instance: CLSID_MSSQL_ClientVirtualDeviceSet, x80040154

System.InvalidProgramException
at MSBackupPipe.VirtualBackupDevice.VirtualDeviceSet..ctor() in c:\documents
and settings\clay lenhart\my documents\mssqlcompressed\msbackuppipe.virtualbacku
pdevice\virtualdeviceset.cpp:line 50
at MSBackupPipe.Common.BackupPipeSystem.BackupOrRestore(Boolean isBackup, Con
figPair storageConfig, ConfigPair databaseConfig, List`1 pipelineConfig, IUpdate
Notification updateNotifier) in C:\Documents and Settings\Clay Lenhart\My Docume
nts\mssqlcompressed\MSBackupPipe.Common\BackupPipeSystem.cs:line 179
at cMSBackupPipe.Common.BackupPipeSystem.Backup(ConfigPair databaseConfig, Lis
t`1 pipelineConfig, ConfigPair storageConfig, IUpdateNotification updateNotifier
) in C:\Documents and Settings\Clay Lenhart\My Documents\mssqlcompressed\MSBacku
pPipe.Common\BackupPipeSystem.cs:line 51
at MSBackupPipe.Cmd.Program.Main(String[] args) in C:\Documents and Settings\ Clay Lenhart\My Documents\mssqlcompressed\MSBackupPipe.Cmd\Program.cs:line 111

The backup failed.

I am running this tool on Windows server 2003 32-bit Service Pack 2. (remotely) What am I doing wrong? Is it the command? I have the tool and the backup database in a different folder, does it matter? I am not familiar with this tool yet.
Any help would be appreciated.

Discussion


Log in to post a comment.