![]() ![]() Then changed the last switch to be: switch (oldProactiveSql.InstanceName) S = "BACKUP DATABASE " dbName " TO DISK = \'" string.Concat dbName, ".bak") "\'\n" ![]() I changed my code to add: private static void WriteBackupSp (Server remoteServer, string dbName, out string storedProcedure) Then the path will relative to where the sql is executed. Thank you sure you would need to use dynamic sql in this case. ServerConnection srvConn2 = new ServerConnection("machinename"/* <-default sql instance on machinename*/) // or for named instancesĬonsole.WriteLine("servername:\n",, (string.IsNullOrEmpty(())? "**": ()) ) For remote connection, remote server name / ServerInstance needs to be specified the backup is split into 3 files, each file residing in a different directory(sql instance backup dir
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |