BCP Command

Open the Command Prompt and use the following command for quick and fast backup.

Selected Query:


BCP "select * from GBRVIEW.dbo.CDR_0(nolock) where charging_timestamp between '2011-05-01' and '2011-05-31 23:59:59.997' and CDR_SPECIFIC_ID not in (select CDR_SPECIFIC_ID from GBRVIEW.dbo.cdr201105(nolock))" queryOut V:\May_CDR_0_Archive\GBRVIEW_CDR_PartCDRMay11_MISSING2_May11.txt -c -T -S LEB-ODSMSSQL2

Whole table without any condition:

BCP gbrview.dbo.cdr201105 Out T:\cdrbACKUP\GBRCDR201105.txt -c -T -S LEB-ODSMSSQL2