473,322 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL Vb.Net 2005

Is there a way to backup and restore an SQL database with Vb.Net 2005
May 22 '07 #1
11 2811
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

May 22 '07 #2
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
May 22 '07 #3
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
May 22 '07 #4
Try :
http://msdn2.microsoft.com/en-us/lib...ry(vs.71).aspx

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

---
Patrice

<Je**@aol.coma écrit dans le message de news:
hv********************************@4ax.com...
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

May 22 '07 #5
"Robin Tucker" <rt******@removehotmail.comwrote in
news:f2*******************@news.demon.co.uk:
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 :-)
May 22 '07 #6
A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068

Cor

<Je**@aol.comschreef in bericht
news:q3********************************@4ax.com...
Is there a way to backup and restore an SQL database with Vb.Net 2005

May 22 '07 #7

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:uY**************@TK2MSFTNGP05.phx.gbl...
>A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068

Cor

<Je**@aol.comschreef in bericht
news:q3********************************@4ax.com...
>Is there a way to backup and restore an SQL database with Vb.Net 2005

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

May 22 '07 #8
Thanks unfortunately the machine I am working uses Microsoft SQL
Server 2000

On Tue, 22 May 2007 19:31:56 +0200, "Cor Ligthert [MVP]"
<no************@planet.nlwrote:
>A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068

Cor

<Je**@aol.comschreef in bericht
news:q3********************************@4ax.com.. .
>Is there a way to backup and restore an SQL database with Vb.Net 2005
May 23 '07 #9
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

<Je**@aol.comwrote in message
news:sl********************************@4ax.com...
Thanks unfortunately the machine I am working uses Microsoft SQL
Server 2000

On Tue, 22 May 2007 19:31:56 +0200, "Cor Ligthert [MVP]"
<no************@planet.nlwrote:
>>A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068

Cor

<Je**@aol.comschreef in bericht
news:q3********************************@4ax.com. ..
>>Is there a way to backup and restore an SQL database with Vb.Net 2005

May 23 '07 #10
Lloyd,

Thanks I saw it, we will take action.

Cor

"Lloyd Sheen" <a@b.cschreef in bericht
news:FE**********************************@microsof t.com...
>
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:uY**************@TK2MSFTNGP05.phx.gbl...
>>A code sample fom Ken,

http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068

Cor

<Je**@aol.comschreef in bericht
news:q3********************************@4ax.com.. .
>>Is there a way to backup and restore an SQL database with Vb.Net 2005


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

May 23 '07 #11


*** Sent via Developersdex http://www.developersdex.com ***
May 29 '07 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.