sqlcmd Backup to current working directory

• ArjunaReddy

  Default port

  Points: 1467

  More actions

  September 23, 2009 at 4:51 am

  #214691

  Hi,

  Could anyone tell me how should i modify the following sqlcmd which will pull the backup of the databse to the Present working directory (PWD)

  Lets say if you kick off the following command being in D: (Directory), the bak file should generated at D:.

  sqlcmd -E -S MB3DS1022 -Q"BACKUP DATABASE [SFB10D02] TO DISK = N'.\SFB10D02.bak' WITH NOFORMAT, NOINIT,NAME = N'SFB10D02-Full Database Backup',SKIP,NOREWIND, NOUNLOAD,STATS = 10"