Is there a way to backup and restore an SQL database with Vb.Net 2005
-
-
Re: SQL Vb.Net 2005
Jeff@aol.com wrote in news:q3o453182b 7hstkur53981pdt 7qciv74rg@4ax.c om:
You can issue the backup command through T-SQL:Is there a way to backup and restore an SQL database with Vb.Net 2005
http://msdn2.microsoft.com/en-us/library/ms186865.aspx
-
Re: SQL Vb.Net 2005
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
<spamhoneypot@r ogers.comwrote:
>Jeff@aol.com wrote in news:q3o453182b 7hstkur53981pdt 7qciv74rg@4ax.c om:
>>>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.aspxComment
-
Re: SQL Vb.Net 2005
Hi Jeff,
You should use the SMO libraries. A much more programmer-friendly way of
doing things:
Robin
Comment
-
Re: SQL Vb.Net 2005
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
<Jeff@aol.com a écrit dans le message de news:
hvc553hvu0labc6 8mi5eadpag3m0m8 f2i5@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
<spamhoneypot@r ogers.comwrote:
>>>>Jeff@aol.co m wrote in news:q3o453182b 7hstkur53981pdt 7qciv74rg@4ax.c om:
>>>>>>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
Comment
-
Re: SQL Vb.Net 2005
"Robin Tucker" <rtgroups@remov ehotmail.comwro te in
news:f2ud7s$a13 $1$8300dec7@new s.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 :-)
Comment
-
Re: SQL Vb.Net 2005
A code sample fom Ken,
Cor
<Jeff@aol.comsc hreef in bericht
news:q3o453182b 7hstkur53981pdt 7qciv74rg@4ax.c om...Is there a way to backup and restore an SQL database with Vb.Net 2005
Comment
-
Re: SQL Vb.Net 2005
"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:uYcImaJnHH A.1776@TK2MSFTN GP05.phx.gbl...Cor,>A code sample fom Ken,
>
>
Cor
>
>
>
<Jeff@aol.comsc hreef in bericht
news:q3o453182b 7hstkur53981pdt 7qciv74rg@4ax.c om...>>Is there a way to backup and restore an SQL database with Vb.Net 2005
>
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
Comment
-
Re: SQL Vb.Net 2005
Thanks unfortunately the machine I am working uses Microsoft SQL
Server 2000
On Tue, 22 May 2007 19:31:56 +0200, "Cor Ligthert [MVP]"
<notmyfirstname @planet.nlwrote :
>A code sample fom Ken,
>
>http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068
>
>Cor
>
>
>
><Jeff@aol.coms chreef in bericht
>news:q3o453182 b7hstkur53981pd t7qciv74rg@4ax. com...>>Is there a way to backup and restore an SQL database with Vb.Net 2005Comment
-
Re: SQL Vb.Net 2005
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).
Robin
<Jeff@aol.comwr ote in message
news:sl675316eh j44a6nc9ud81138 fqkgo8k4i@4ax.c om...Thanks unfortunately the machine I am working uses Microsoft SQL
Server 2000
>
On Tue, 22 May 2007 19:31:56 +0200, "Cor Ligthert [MVP]"
<notmyfirstname @planet.nlwrote :
>>>>A code sample fom Ken,
>>
>>http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068
>>
>>Cor
>>
>>
>>
>><Jeff@aol.com schreef in bericht
>>news:q3o45318 2b7hstkur53981p dt7qciv74rg@4ax .com...>>>>Is there a way to backup and restore an SQL database with Vb.Net 2005
Comment
-
Re: SQL Vb.Net 2005
Lloyd,
Thanks I saw it, we will take action.
Cor
"Lloyd Sheen" <a@b.cschreef in bericht
news:FE552D1A-8648-494C-AC3B-7CC0432825F9@mi crosoft.com...>
"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
news:uYcImaJnHH A.1776@TK2MSFTN GP05.phx.gbl...>>>A code sample fom Ken,
>>
>http://www.vb-tips.com/dbpages.aspx?...a-eb3bdb382068
>>
>Cor
>>
>>
>>
><Jeff@aol.coms chreef in bericht
>news:q3o453182 b7hstkur53981pd t7qciv74rg@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
Comment
-
Comment