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"