SQL Vb.Net 2005 [英] SQL Vb.Net 2005

问题描述

有没有办法用Vb.Net 2005备份和恢复SQL数据库

解决方案

Je ** @ aol.com 在新闻中写道：q3 **************************** ****@4ax.com:

有没有办法用Vb.Net 2005备份和恢复SQL数据库

您可以通过T-SQL发出备份命令：

http://msdn2.microsoft.com/en-us/library/ms186865.aspx

你能指导一下如何使用

Vb.net运行T-SQl的示例代码。谢谢你


2007年5月22日星期二03:37:56 GMT，Spam Catcher

< sp ********** @ rogers.comwrote：

> Je ** @ aol.com在新闻中写道：q3 *************** *****************@4ax.com:

>有没有办法备份和恢复SQL数据库与Vb.Net 2005

您可以通过T-SQL发出备份命令：

http://msdn2.microsoft.com/en-us/library/ms186865.aspx

您好Jeff，

您应该使用SMO库。一个更加程序员友好的方式

做事：

http://www.sqldbatips.com/showarticle.asp?ID=34


Robin

Is there a way to backup and restore an SQL database with Vb.Net 2005

解决方案

Je**@aol.com wrote in news:q3********************************@4ax.com:

Is there a way to backup and restore an SQL database with Vb.Net 2005

You can issue the backup command through T-SQL:

http://msdn2.microsoft.com/en-us/library/ms186865.aspx

Can you direct me to sample code as to how to run T-SQl withing
Vb.net. Thank uou

On Tue, 22 May 2007 03:37:56 GMT, Spam Catcher
<sp**********@rogers.comwrote:

>Je**@aol.com wrote in news:q3********************************@4ax.com:

>Is there a way to backup and restore an SQL database with Vb.Net 2005

You can issue the backup command through T-SQL:

http://msdn2.microsoft.com/en-us/library/ms186865.aspx

Hi Jeff,
You should use the SMO libraries. A much more programmer-friendly way of
doing things:

http://www.sqldbatips.com/showarticle.asp?ID=34

Robin

这篇关于SQL Vb.Net 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！