Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sqlcmd Backup to current working directory Expand / Collapse
Author
Message
Posted Wednesday, September 23, 2009 4:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 22, 2014 3:57 AM
Points: 45, Visits: 538
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"
Post #792518
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse