[Mssqlcompressed-users] MSBP compressed backup over TCP/IP
Brought to you by:
xclayl
From: Patel, S. <sp...@cm...> - 2013-06-12 13:25:24
|
Hi, Currently I have a 100GB DB on SQL Server 2005 and the backup runs very slow over NAMEDPIPE. Can I define as parameter to use TCP/IP? My code is here Z:\MSSQLCompressBKP\msbp.exe backup "db(database=CMT_Txn;clusternetworkname=DBServer;backuptype=full;filegroup=primary;checksum)" zip64 "local(path=z:\MSSQL\BACKUP\FULL\CMT_Txn\CMT_Txn.full.bak;path=z:\MSSQL\BACKUP\FULL\CMT_Transaction\CMT_Txn.full.2.bak)" *Sushil Patel* Sr. Database Administrator / Architect Creative Mobile Technologies, LLC 5803 Kennett Pike Suite C | Wilmington, DE 19807 302-660-3740 | SP...@cm... |