SQL table does not backup with bcp C# -
i using following codes backup tables in sql database.
//passenger table backup psi = new processstartinfo(); psi.filename = "bcp.exe"; psi.arguments = @"passenger out backup\backuppassenger.csv -t -d crashflight101 -w"; process.start(psi); //pilot table backup psi = new processstartinfo(); psi.filename = "bcp.exe"; psi.arguments = @"pilot out backup\backuppilot.csv -t -d crashflight101 -w"; process.start(psi); //user table backup psi = new processstartinfo(); psi.filename = "bcp.exe"; psi.arguments = @"user out backup\backupuser.csv -t -d crashflight101 -w"; process.start(psi);
for reason doesn't want backup user table , can't seem see why. each table has same permissions , created same way. simple database design no schema structure. appreciated.
Comments
Post a Comment