October 22, 2001 at 8:24 pm
How can I use VBScript (and DMO) to stop the SQL Service service on a remote SQL 7 machine, copy trans logs from that machine, and then restart the SQL service?
October 23, 2001 at 5:55 am
Here is a starting point for you. See what you can do with this:
On Error Resume Next
Set oServer = New SQLDMO.SQLServer
With oServer
.LoginSecure = True
.Connect "."
.Shutdown
End With
Set oServer = Nothing
'do the file copy here
Set oServer = New SQLDMO.SQLServer
oServer.Start False, "."
Set oServer = Nothing
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy