Hi guys,
This is the code you would use to trigger a full sql 2005 backup to a .BK file from a ASPX page, i use that on www.Love2Trade.com
****You want to put this code somethere in the website that only YOU have access to (Admin page or something)****
//ASPX File
<br /> <fieldset style="padding:5px"><legend>Database Backup</legend><br /> Server: <asp:TextBox CssClass="box" ID="txtServer" Text="ServerName\Instance" runat="server" Width="150px"/><br /><br /> Database: <asp:TextBox CssClass="box" ID="txtDatabase" Text="DBName" runat="server" Width="150px"/><br /><br /> User: <asp:TextBox CssClass="box" ID="txtUser" Text="user" runat="server" Width="70px"/><br /><br /> Pass: <asp:TextBox CssClass="box" ID="txtPass" Text="" TextMode="Password" runat="server" Width="70px"/><br /> Backup to: <asp:TextBox CssClass="box" ID="txtBKLocation" Text="" runat="server" Width="250px"/><br /><asp:Button CssClass="box" ID="btnBackup" runat="server" Text="Start Backup" OnClick="btnBackup_Clicked" /> <br /><asp:Literal ID="lblErr" runat="server" /></fieldset><br />
//Code Behind
<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
txtBKLocation.Text =Request.MapPath(DateTime.Now.Ticks+".bk") ;<br />
}</p>
<p><p style="margin:0;"> protected void btnBackup_Clicked(object sender, EventArgs e)<br />
{<br />
try<br />
{<br />
ServerConnection sc=new ServerConnection(txtServer.Text,txtUser.Text,txtPass.Text);<br />
Server svr = new Server(sc);<br />
Backup bkp = new Backup();<br />
bkp.Devices.AddDevice(txtBKLocation.Text, DeviceType.File);<br />
bkp.Database = txtDatabase.Text;<br />
bkp.Action = BackupActionType.Database;<br />
bkp.Initialize = true;<br />
bkp.PercentCompleteNotification = 10;<br />
// bkp.PercentComplete += new PercentCompleteEventHandler(bkp_PercentComplete);<br />
bkp.SqlBackup(svr);<br />
lblErr.Text = "<span style='color:#0F0'>Done!</span>";<br />
}catch(Exception ee)<br />
{<br />
lblErr.Text = ee.Message + "<br/>" + ee.StackTrace + "<br/>" + ee.InnerException.Message + "<br/>" + ee.InnerException.StackTrace;<br />
}<br />
}
Ash
Filed under: Technical
