SQL Vb.Net 2005

[Jeff]

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

 

[Guest]

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

 

[Jeff]

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

 

[Robin Tucker]

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

 

[Patrice]

Try :
http://msdn2.microsoft.com/en-us/li...client.sqlcommand.executenonquery(vs.71).aspx

The general documentation for ADO.NET is :
http://msdn2.microsoft.com/en-us/library/e80y5yhx.aspx

 

[Guest]

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

Neato - totally forgot about these. I'm still stuck on SQL Server 2000

 

[Cor Ligthert [MVP]]

A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?ID=53524c9b-096f-42da-a5da-eb3bdb382068

Cor

 

[Lloyd Sheen]

A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?ID=53524c9b-096f-42da-a5da-eb3bdb382068

Cor

Cor,

Every time I go to that site (every link you provide) the site shows
info for a second and then changes to a blue screen with "Select a tip to
display (Show the Details).

On the link you provided above if I click the "Show" link I can see
"Select a SQLClient Tip to display" with SQLCRL: Create a custom function as
the only "tip"?

It is like my browser is out of sync with the site although I think it
is really the other way around?? I checked for cookies but can see none
that from that site.

Lloyd Sheen

 

[Jeff]

Thanks unfortunately the machine I am working uses Microsoft SQL
Server 2000

 

[Robin Tucker]

Jeff,

If you are using SQL 2000 you can always use SQLDMO. I'm not sure how the
SMO libraries ship - I know they aren't SQL 2005 specific, i.e. you can
still access databases on SQL 2000 with them. So those would be better, but
my older SQL 2000 project is using SQLDMO quite happily.

This is an example here (scroll down).

http://www.sqldev.net/sqldmo/SQL-DMO.NETEventsVB.htm



Robin

 

[Cor Ligthert [MVP]]

Lloyd,

Thanks I saw it, we will take action.

Cor