I am trying to backup database using C# code and i couldnt get it working. The server is SQL server 2005
Error for backup Backup failed for Server 'BDServer\\sql1'. \r\nStackTrace : at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)\r\n at BackupRestore.Program.Main(String[] args) in C:\\Documents and Settings\\tvs1\\Desktop\\BackupRestore\\BackupRestore\\Program.cs:line 84\r\nInner1 : Cannot write property CompressionOption. This property is not available on SQL Server 2005.\r\n
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using Microsoft.SqlServer.Management.Smo;
namespace BackupRestore
{
class Program
{
static void Main(string[] args)
{
string MachineName="BDServer\\sql1";
string DBName="TEST";
string backupName = "Backup";
Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(MachineName);
Database db = server.Databases[DBName];
//To Avoid TimeOut Exception
server.ConnectionContext.StatementTimeout = 60 * 60;
RecoveryModel recoverymodel = db.DatabaseOptions.RecoveryModel;
//Define a Backup object variable.
Backup backup = new Backup();
backup.CompressionOption = BackupCompressionOptions.On;
//Specify the type of backup, the description, the name, and the database to be backed up.
backup.Action = BackupActionType.Database;
backup.BackupSetDescription = "Full backup of " + DBName + ".";
backup.BackupSetName = backupName;
backup.Database = DBName;
//Declare a BackupDeviceItem
BackupDeviceItem bdi = default(BackupDeviceItem);
bdi = new BackupDeviceItem(@"L:\ACM\Temp\Vinu\" + backupName + ".bak", DeviceType.File);
//Add the device to the Backup object.
backup.Devices.Add(bdi);
//Set the Incremental property to False to specify that this is a full database backup.
backup.Incremental = false;
//Set the expiration date.
System.DateTime backupdate = new System.DateTime();
backupdate = new System.DateTime(2008, 10, 5);
backup.ExpirationDate = backupdate;
//Specify that the log must be truncated after the backup is complete.
backup.LogTruncation = BackupTruncateLogType.Truncate;
//Run SqlBackup to perform the full database backup on the instance of SQL Server.
try
{
backup.SqlBackup(server);
}
catch (Exception ex)
{
String str = "Error for backup " + ex.Message + Environment.NewLine;
str += "StackTrace : " + ex.StackTrace + Environment.NewLine;
if (ex.InnerException != null)
{
str += "Inner1 : " + ex.InnerException.Message + Environment.NewLine;
if (ex.InnerException.InnerException != null)
{
str += "Inner2 : " + ex.InnerException.InnerException.Message + Environment.NewLine;
}
}
Console.WriteLine(str);
Console.ReadLine();
}
//Remove the backup device from the Backup object.
backup.Devices.Remove(bdi);
}
}
}
Microsoft and Crowdstrike announce partnership on threat actor naming by Pradeep Viswanathan
Whenever a cyberattack is discovered, companies disclose it to the public and assign it a unique name based on their internal procedures. Unfortunately, this leads to inconsistencies, as each company has its own naming conventions. As a result, the same threat actor behind a cyberattack may end up with multiple names, causing delays and confusion in response efforts.
For example, a threat actor that Microsoft refers to as Midnight Blizzard might be known as Cozy Bear, APT29, or UNC2452 by other security vendors.
To address this issue, Microsoft and CrowdStrike are teaming up. These companies will align their individual threat actor taxonomies to help security professionals respond to cyberattacks with greater clarity and confidence.
It’s important to note that Microsoft and CrowdStrike are not attempting to create a single naming standard. Instead, they are releasing a mapping that lists common threat actors tracked by both companies, matched according to their respective taxonomies. The mapping also includes corresponding aliases from each group’s naming system. You can view the joint threat actor mapping by Microsoft and CrowdStrike here.
Although this threat actor taxonomy mapping is a joint effort between Microsoft and CrowdStrike, Google/Mandiant and Palo Alto Networks' Unit 42 are expected to contribute to this initiative in the future.
Vasu Jakkal, Corporate Vice President of Microsoft Security, wrote the following about this collaboration with CrowdStrike:
As more organizations join this initiative, the collective defense against cyber threats will undoubtedly be improved.
You make no sense since most of the stuff on YouTube is free to begin with. Comparing Netflix to YouTube is not even remotely the same. YouTube has tons of free videos to begin with, unlike Netflix, you are paying Netflix for original style of programming.
Question
still1
Hi Guys,
I am trying to backup database using C# code and i couldnt get it working. The server is SQL server 2005
Error for backup Backup failed for Server 'BDServer\\sql1'. \r\nStackTrace : at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)\r\n at BackupRestore.Program.Main(String[] args) in C:\\Documents and Settings\\tvs1\\Desktop\\BackupRestore\\BackupRestore\\Program.cs:line 84\r\nInner1 : Cannot write property CompressionOption. This property is not available on SQL Server 2005.\r\n
Help appreciated
Link to comment
https://www.neowin.net/forum/topic/863830-backup-databasesql-server-2005-using-c/Share on other sites
1 answer to this question
Recommended Posts