How Do i Backup and Restore a LocalDataBase? in c# Win App.

Microsoft.SqlServer.Smo
Microsoft.SqlServer.SmoExtended
Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.SqlEnum
string ServerName = "server";
string DatabaseName = database;
string UserId = userId;
string Password = password;
ServerConnection serverConnection;
private Server _server;
public Server Server
{
get
{
if (_server == null)
{
Connect();
}
return _server;
}
}
string connectionString
{
get
{
return string.Format("Data Source={0};Initial Catalog={1};UID={2};Password={3}", ServerName, DatabaseName, UserId, Password);
}
}
public void Connect()
{
_serverConnection = new ServerConnection();
_serverConnection.LoginSecure = false;
_serverConnection.Login = UserId;
_serverConnection.Password = Password;
_server = new Server(_serverConnection);
}
public void BackupDatabase()
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
ServerConnection svCon = new ServerConnection(cn);
Server svr = new Server(svCon);
cn.Open();
cn.ChangeDatabase("master");
string testFolder = @"C:\temp";
string databaseName = _databaseName;
Backup backup = new Backup();
backup.Action = BackupActionType.Database;
backup.Database = databaseName;
backup.Incremental = false;
backup.Initialize = true;
backup.LogTruncation = BackupTruncateLogType.Truncate;
string fileName = string.Format("{0}\\{1}.bak", testFolder, databaseName);
BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
backup.Devices.Add(backupItemDevice);
backup.PercentCompleteNotification = 10;
//backup.PercentComplete += backup_PercentComplete;
//backup.Complete += backup_Complete;
backup.SqlBackup(svr);
if (!VerifyBackup(svr))
{
//throw new Exception("Backup could not be verified.");
}
svr = null;
cn.Close();
}
}
public bool VerifyBackup(Server svr)
{
string testFolder = @"C:\temp";
string databaseName = _databaseName;
Restore restore = new Restore();
restore.Action = RestoreActionType.Database;
string fileName = string.Format("{0}\\{1}.bak", testFolder, databaseName);
BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
restore.Devices.AddDevice(fileName, DeviceType.File);
restore.Database = databaseName;
restore.PercentCompleteNotification = 10;
//restore.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler);
bool verified = restore.SqlVerify(svr);
return verified;
}
public void RestoreDatabase()
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
ServerConnection svCon = new ServerConnection(cn);
Server svr = new Server(svCon);
cn.Open();
cn.ChangeDatabase("master");
string testFolder = @"C:\temp";
string databaseName = _databaseName;
Restore restore = new Restore();
restore.Action = RestoreActionType.Database;
string fileName = string.Format("{0}\\{1}.bak", testFolder, databaseName);
BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
restore.Devices.AddDevice(fileName, DeviceType.File);
restore.Database = databaseName;
restore.ReplaceDatabase = true;
restore.PercentCompleteNotification = 10;
//restore.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler);
svr.KillAllProcesses(databaseName);
restore.SqlRestore(svr);
svr = null;
cn.Close();
}
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain9y ago
1. Microsoft.SqlServer.Smo
2. Microsoft.SqlServer.SmoExtended
3. Microsoft.SqlServer.ConnectionInfo
4. Microsoft.SqlServer.Management.Sdk.Sfc
5. Microsoft.SqlServer.SqlEnum
6. string ServerName = "server";
7. string DatabaseName = database;
8. string UserId = userId;
9. string Password = password;
10. ServerConnection serverConnection;
12. private Server _server;
13. public Server Server
14. {
15. get
16. {
17. if (_server == null)
18. {
19. Connect();
20. }
21. return _server;
22. }
23. }
25. string connectionString
26. {
27. get
28. {
29. return string.Format("Data Source={0};Initial Catalog={1};UID={2};Password={3}", ServerName, DatabaseName, UserId, Password);
30. }
31. }
33. public void Connect()
34. {
35. _serverConnection = new ServerConnection();
36. _serverConnection.LoginSecure = false;
37. _serverConnection.Login = UserId;
38. _serverConnection.Password = Password;
40. _server = new Server(_serverConnection);
41. }
43. public void BackupDatabase()
44. {
45. using (SqlConnection cn = new SqlConnection(connectionString))
46. {
47. ServerConnection svCon = new ServerConnection(cn);
48. Server svr = new Server(svCon);
49. cn.Open();
50. cn.ChangeDatabase("master");
52. string testFolder = @"C:\temp";
53. string databaseName = _databaseName;
54. Backup backup = new Backup();
55. backup.Action = BackupActionType.Database;
56. backup.Database = databaseName;
57. backup.Incremental = false;
58. backup.Initialize = true;
59. backup.LogTruncation = BackupTruncateLogType.Truncate;
61. string fileName = string.Format("{0}\\{1}.bak", testFolder, databaseName);
62. BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
63. backup.Devices.Add(backupItemDevice);
64. backup.PercentCompleteNotification = 10;
65. //backup.PercentComplete += backup_PercentComplete;
66. //backup.Complete += backup_Complete;
68. backup.SqlBackup(svr);
69. if (!VerifyBackup(svr))
70. {
71. //throw new Exception("Backup could not be verified.");
72. }
73. svr = null;
74. cn.Close();
75. }
76. }
78. public bool VerifyBackup(Server svr)
79. {
80. string testFolder = @"C:\temp";
81. string databaseName = _databaseName;
82. Restore restore = new Restore();
83. restore.Action = RestoreActionType.Database;
84. string fileName = string.Format("{0}\\{1}.bak", testFolder, databaseName);
85. BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
86. restore.Devices.AddDevice(fileName, DeviceType.File);
87. restore.Database = databaseName;
88. restore.PercentCompleteNotification = 10;
89. //restore.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler);
91. bool verified = restore.SqlVerify(svr);
92. return verified;
93. }
95. public void RestoreDatabase()
96. {
97. using (SqlConnection cn = new SqlConnection(connectionString))
98. {
99. ServerConnection svCon = new ServerConnection(cn);
100. Server svr = new Server(svCon);
101. cn.Open();
102. cn.ChangeDatabase("master");
104. string testFolder = @"C:\temp";
105. string databaseName = _databaseName;
106. Restore restore = new Restore();
107. restore.Action = RestoreActionType.Database;
108. string fileName = string.Format("{0}\\{1}.bak", testFolder, databaseName);
109. BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
110. restore.Devices.AddDevice(fileName, DeviceType.File);
111. restore.Database = databaseName;
112. restore.ReplaceDatabase = true;
113. restore.PercentCompleteNotification = 10;
114. //restore.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler);
115. svr.KillAllProcesses(databaseName);
117. restore.SqlRestore(svr);
118. svr = null;
119. cn.Close();
120. }
121. }

How Do i Backup and Restore a LocalDataBase? in c# Win App.

Nilesh Shah Sir. actully i dont want to share Source Code. But If You Like To Help Me. I would like you contact you personly on mobile. If You Dont Mind Give Me Your Contact Number and Give me a time when we can talk...

Nilesh Shah Sir.
actully i dont want to share Source Code.
But If You Like To Help Me. I would like you contact you personly on mobile. If You Dont Mind Give Me Your Contact Number and Give me a time when we can talk...