Hi I want to know how to take a backup of database using programatically in VB.net of SQL Server 2005. if you are having and idea about it then pls send me the code for that.
A:
You can achieve this by using Sql Management Object. SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server.
Refer How to: Back Up Databases and Transaction Logs in Visual Basic .NET
ARS
2010-04-30 11:02:02