SQL server: How to get backup file information using SMO
-
SQL server 2014/2016, SMO. Using SMO to backup a databse to 'D:\SQLBK\Mon\dbc.bak' on server: 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; } How to get original database information from backup file 'D:\SQLBK\Mon\dbc.bak' through SMO? e.g. database name.
-
SQL server 2014/2016, SMO. Using SMO to backup a databse to 'D:\SQLBK\Mon\dbc.bak' on server: 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; } How to get original database information from backup file 'D:\SQLBK\Mon\dbc.bak' through SMO? e.g. database name.
w14243 wrote:
How to get original database information from backup file 'D:\SQLBK\Mon\dbc.bak' through SMO? e.g. database name.
The database-name is not part of the backup. You backup the data, not meta-data on the file.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)