You need to run BABR as administrator and provide SQL credential with enough permissions for Backup/restore.

In old Windows, such as Windows 2003 Server, there is some tricks. To get Administrator Console in Win2003 Server,

RUNAS /USER:administrator cmd.exe

1. Full Backup of Database [TestDB] of default instance to sigle file

   [AppPath]>gabr -a=B -b=F -d=TestDB -f="c:\temp\1.bak" -u=sa -p=********

   
   

2. Full Backup of Database [TestDB] of default instance to 3 files by trusted connection

   [AppPath]>gabr -a=B -b=F -d=TestDB -f="c:\temp\1.bak,c:\temp\2.bak,c:\temp\3.bak" -e
   								
   or
   [AppPath]>gabr -a=B -b=F -d=TestDB -f="3@c:\temp" -e

   
   

3. Differential Backup of Database [TestDB] of instance SQL2000 to sigle file

   [AppPath]>gabr -a=B -b=D -d=TestDB -f="c:\temp\1.bak" -u=sa -p=******** -i="SERVER\SQL2000"

   
   

4. Compression(build-in) Log Backup of Database [TestDB] of default instance

   [AppPath]>gabr -a=B -b=L -d=TestDB -f="c:\temp\1.bak" -e -Z=B

   * Log Backup means, DB should be in FULL/Bulk-Logged Recovery Mode.

   * Build-in Compression is only available in SQL Server 2008 or above.

   
   

5. Compression(Zlib with CompressionLevel=4) Log Backup of Database [TestDB] of default instance

   [AppPath]>gabr -a=B -b=F -d=TestDB -f="c:\temp\1.bak" -u=sa -p=******** -Z=L -z=4

   
   

6. Full Backup of Database [TestDB] of default instance with CHECKSUM and COPY_ONLY

   [AppPath]>gabr -a=B -b=F -d=TestDB -f="c:\temp\1.bak" -u=sa -p=******** -o=CS

   * COPY_ONLY may not be supported some old SQL Server versions, such as SQL 2000 and SQL 2005.

   
   

7. Full Backup Database [TestDB] to remote instance

   Step 1 - Start Restore Service by TCP-8080 in Remote Instance

   [AppPath]>gabr -l=8080 -u=sa -p=********

   Step 2 - Start Full Backup

   [AppPath]>gabr -a=B -b=F -d=TestDB -f="tcp://IP:8080" -u=sa -p=********

   * If DB has already existed in remote instance, it will get replaced.

   * Compression is NOT supported for now. Will be supported very soon.

   
   

8. Full Backup of Database [TestDB] to AWS S3

   [AppPath]>gabr -a=B -b=F -d=TestDB -f="s3://BucketName/temp/1.bak" -u=sa -p=******** -k=S3Key -s=S3Secret

   * It's NOT supported by Special Version.

   * Bucket must be ready.

   
   

9. Restore Database [TestDB] from AWS S3

   [AppPath]>gabr -a=R -b=F -d=TestDB -f="s3://BucketName/temp/1.bak" -u=sa -p=******** -k=S3Key -s=S3Secret

   
   

10. Verify Backup

    [AppPath]>gabr -a=V -f="c:\temp\1.bak" -u=sa -p=********

    
    

11. Verify Backup in multiple files

    [AppPath]>gabr -a=V -d=TestDB -f="4@c:\temp" -z=L -u=sa -p=********

    Note, (1) When using shortcut-format file names for Verify or Restore, such as 4@c:\temp, we need provide the name of original database name. Otherwise, gabr can NOT find the correct files. (2)If customized compression is enable when backup, -z=L is need for Verify or Restore

    
    

12. Restore by Full Backup of Database [TestDB]

    [AppPath]>gabr -a=R -b=F -d=TestDB -f="c:\temp\1.bak" -u=sa -p=********

    
    

13. Restore by Differential Backup of Database [TestDB] with NORECOVERY

    [AppPath]>gabr -a=R -b=D -d=TestDB -f="c:\temp\2.bak" -u=sa -p=******** -O=N