How to create SQL Server backup folder
-
SQL Server 2014/2016, using SMO. Want backup database 'dbName' of server 'serverName' to server folder 'backupFolder'. 1.Backup remote database, not backup local database. 2.The 'backupFolder' is on remote server, e.g. "D:\SQLBK\Mon". public int BackupDB(string serverName, string dbName, string backupFolder) { Server oServer = new Server(new ServerConnection(ServerName)); Backup oBackup = new Backup(); oBackup.Action = BackupActionType.Database; oBackup.Database = dbName; oBackup.Initialize = false; oBackup.Incremental = false; oBackup.LogTruncation = BackupTruncateLogType.Truncate; string sBackupFilename = Path.Combine(backupFolder, dbName + ".bak"); oBackup.Devices.AddDevice(sBackupFilename, DeviceType.File); oBackup.SqlBackup(oServer); return 0; } The 'backupFolder' is folder on 'serverName', not local folder. 1.If 'backupFolder' is not exist on 'serverName', the 'SqlBackup' command will cause exception on 'folder not exist'. 2.If use 'Directory.CreateDirectory(backupFolder)', then local folder will be created, not remote folder. So I want: 1. The 'SqlBackup' command can auto create specified backup folder. How to do it? 2. If above can't be done, then how to create 'backupFolder' on 'serverName' by SMO or other method?