How to backup SQL Server database using VB.NET?

public class BackupManager
 
{
 
    Server srvSql;
    SaveFileDialog saveBackupDialog = new SaveFileDialog();
    OpenFileDialog openBackupDialog = new OpenFileDialog();
    DatabaseCache dbCache = DatabaseCache.Instance;
 
    private string GetAppPath()
    {
        return System.IO.Path.GetDirectoryName
 
            (System.Windows.Forms.Application.ExecutablePath);
 
    }
 
 
 
    private void Connect()
 
    {
 
        ServerConnection srvConn = new 
 
              ServerConnection(dbCache.SqlConnection);
 
        srvSql = new Server(srvConn);
 
    }
 
 
 
    private string GetDatabase(SqlConnection conn)
 
    {
 
        string[] connArray = conn.ConnectionString.Split(';');
 
        string toMatch = "AttachDbFilename=";
 
        string match = null;
 
        foreach (string item in connArray) {
 
            if (item.StartsWith(toMatch))
 
            {
 
                match = item.Substring(toMatch.Length);
 
                break;
 
            }
 
        }
 
        if (!String.IsNullOrEmpty(match) ) {
 
            match = match.Replace("|DataDirectory|", GetAppPath());
 
        } else {
 
            throw new Exception(
 
              "Could not extract database path from connection string");
 
        }
 
        return match;
 
    }
 
 
 
    public bool MakeBackup()
 
    {
 
        // If there was a SQL connection created
 
        if (srvSql == null) {
 
            Connect();
 
        }
 
 
 
        if (srvSql != null) 
 
        {
 
            string path = GetAppPath();
 
            path = path += @"\Backup";
 
            if (!Directory.Exists(path))
 
            {
 
                Directory.CreateDirectory(path);
 
            }
 
            saveBackupDialog.InitialDirectory = path;
 
            saveBackupDialog.DefaultExt = "bak";
 
 
 
            // If the user has chosen a path 
 
            // where to save the backup file
 
            if (saveBackupDialog.ShowDialog() == DialogResult.OK)
 
            {
 
                // Create a new backup operation
 
                Backup bkpDatabase = new Backup();
 
 
 
                // Set the backup type to a database backup
 
                bkpDatabase.Action = BackupActionType.Database;
 
 
 
                // Set the database that we want to perform a backup on
 
                bkpDatabase.Database = GetDatabase(dbCache.SqlConnection);
 
 
 
                // Set the backup device to a file
 
                BackupDeviceItem bkpDevice = new BackupDeviceItem(saveBackupDialog.FileName, DeviceType.File);
 
 
 
                // Add the backup device to the backup
 
                bkpDatabase.Devices.Add(bkpDevice);
 
 
 
                // Perform the backup
 
                bkpDatabase.SqlBackup(srvSql);
 
            } else {
 
                return false;
 
            }
 
        } else {
 
            throw new Exception("Could not connect to database.");
 
        }
 
        return true;
 
    }
 
 
 
    public void RestoreBackup()
 
    {
 
        //database must first be unloaded before calling this.
 
 
 
        // If there was a SQL connection created
 
        if (srvSql == null)
 
        {
 
            Connect();
 
        }
 
 
 
        if (srvSql != null)
 
        {
 
            openBackupDialog.InitialDirectory = "./Backup";
 
            openBackupDialog.DefaultExt = "bak";
 
 
 
            // If the user has chosen the file from which he wants the database to be restored
 
            if (openBackupDialog.ShowDialog() == DialogResult.OK)
 
            {
 
                // Create a new database restore operation
 
                Restore rstDatabase = new Restore();
 
 
 
                // Set the restore type to a database restore
 
                rstDatabase.Action = RestoreActionType.Database;
 
 
 
                // Set the database that we want to perform the restore on
 
                rstDatabase.Database = GetDatabase(dbCache.SqlConnection);
 
 
 
                // Set the backup device from which we want to restore, to a file
 
                BackupDeviceItem bkpDevice = new BackupDeviceItem(openBackupDialog.FileName, DeviceType.File);
 
 
 
                // Add the backup device to the restore type
 
                rstDatabase.Devices.Add(bkpDevice);
 
 
 
                // If the database already exists, replace it
 
                rstDatabase.ReplaceDatabase = true;
 
 
 
                // Perform the restore
 
                try
 
                {
 
                    rstDatabase.SqlRestore(srvSql);
 
                }
 
                catch (FailedOperationException ex)
 
                {
 
                    Log.WriteLine( "" );
 
                    Log.WriteLine( "Error: (BackupManager.RestoreBackup)" );
 
                    Log.Write( ex );
 
                    throw new Exception("Error while restoring backup.", ex);
 
                }
 
            }
 
            
 
        }
 
        else
 
        {
 
            throw new Exception("Could not connect to database.");
 
        }
 
 
 
    }
 
}
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286: