[RaggiTech]

طبعاً قبل ذلك يجب إضافة References ..

Project->Reference ,add Microsoft SQLDMO Library

بعد إضافة زر امر نضع هذا الكود ..

كود :

[color=#000000][COLOR=#0000bb]Dim SQLSvr [/color][color=#007700]As [/color][color=#0000bb]SQLDMO[/color][color=#007700].[/color][COLOR=#0000bb]SQLServer  
Dim Backup [/COLOR][color=#007700]As [/color][color=#0000bb]SQLDMO[/color][color=#007700].[/color][COLOR=#0000bb]Backup  

Set SQLSvr [/COLOR][color=#007700]= New [/color][color=#0000bb]SQLDMO[/color][color=#007700].[/color][COLOR=#0000bb]SQLServer  

Set Backup [/COLOR][color=#007700]= New [/color][color=#0000bb]SQLDMO[/color][color=#007700].[/color][COLOR=#0000bb]Backup  

SQLSvr[/COLOR][color=#007700].[/color][color=#0000bb]Connect [/color][color=#dd0000]"myserver"[/color][color=#007700], [/color][color=#dd0000]"username"[/color][color=#007700], [/color][COLOR=#dd0000]"password"  

[/COLOR][color=#0000bb]Backup[/color][color=#007700].[/color][color=#0000bb]Database [/color][color=#007700]= [/color][COLOR=#dd0000]"mydatabase"  
[/COLOR][color=#0000bb]Backup[/color][color=#007700].[/color][color=#0000bb]Files [/color][color=#007700]= [/color][COLOR=#dd0000]"c:mydatabase.bak"  
[/COLOR][color=#0000bb]Backup[/color][color=#007700].[/color][COLOR=#0000bb]SQLBackup SQLSvr  
SQLSvr[/COLOR][color=#007700].[/color][COLOR=#0000bb]DisConnect  
Set SQLSvr [/COLOR][color=#007700]= [/color][COLOR=#0000bb]Nothing  
Set Backup [/COLOR][color=#007700]= [/color][COLOR=#0000bb]Nothing  

End Sub  
[/COLOR][/COLOR]

وهذه هي الطريقةالثانية ..