How to backup data?

[Dave Navarro]

We have a client hosting a web site with Verio. It uses an SQL
database.

I can't FTP into the server to download the database, which means I have
to connect to the server and pull all of the records down to do a
backup.

How do I do that? Can someone point me to a source for this procedure?

Thanks!

--Dave

[Manohar Kamath [MVP]]

You could connect via enterprise manager (if verio gives you access) and
backup the database either locally (at the server) or transfer the data to
your local machine. In either case, you need the IP of your SQL server, and
the host should have enabled it on the Net.

Or, look into SQL server books online for SQL commands that let you backup
the database, but you will need the proper permissions.

In all cases, you will need an ok from the host.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1a8d681dddfed936989774@news-40.giganews.com...

> We have a client hosting a web site with Verio. It uses an SQL
> database.
>
> I can't FTP into the server to download the database, which means I have
> to connect to the server and pull all of the records down to do a
> backup.
>
> How do I do that? Can someone point me to a source for this procedure?
>
> Thanks!
>
> --Dave

[Jeff Cochran]

On Fri, 6 Feb 2004 09:00:52 -0500, Dave Navarro <dave@dave.dave>
wrote:

>We have a client hosting a web site with Verio. It uses an SQL
>database.
>
>I can't FTP into the server to download the database, which means I have
>to connect to the server and pull all of the records down to do a
>backup.
>
>How do I do that? Can someone point me to a source for this procedure?

Messy. The problem isn't getting the records, it's the database
structure. If you can run a stored procedure you could back up the
database and download that file.

Jeff

[Dave Navarro]

In article <OwvxlRN7DHA.2412@TK2MSFTNGP09.phx.gbl>,
[email]mkamath@TAKETHISOUTkamath.com[/email] says...

> You could connect via enterprise manager (if verio gives you access) and
> backup the database either locally (at the server) or transfer the data to
> your local machine. In either case, you need the IP of your SQL server, and
> the host should have enabled it on the Net.

Verio has provided access to their server via Enterprise Manager. And I
have SQL 2000 installed on my own personal server.

So I can connect to Verio's server from Enterprise Manager and instruct
it to send the data to my own server?

--Dave

[Don Grover]

Dave here is a script im using, it will backup and email db to you if
required.

'****************************


'************************************************* ***********************
'VBSCRIPT to backup database's and email results
'1 Novenber 2003 Don Grover
'************************************************* ***********************
OPTION EXPLICIT

Dim myMailServer, myRmailPort, sEmailAddFrom, sEmailAddToo, sConEmailMonitor
Dim conn

myMailServer = "myservername"
myRmailPort = 25
sEmailAddFrom = "support@@@@assoft.com.au"
sEmailAddToo = "Don Grover <dgrover@@@@assoft.com.au>"
sConEmailMonitor = ""



'Open connection to SQL Server
Set Conn = CreateObject("ADODB.Connection")
Conn.Open _
"Provider=SQLOLEDB" & _
";Data Source=assoftsvr" & _
";Integrated Security=SSPI"

'Call the backup routine for each db
'DoBackup "GTS"
'DoBackup "CokeShop"
'DoBackup "BGINFO"

Conn.Close
Set Conn = Nothing

'Wscript.Echo "Backup complete"
WScript.Quit



Sub DoBackup(sDbName)
'Sub accepts a database name and backs up to predefined location on another
server
On Error Resume Next
Conn.Execute _
"BACKUP DATABASE " & sDbName & _
" TO DISK='\\nassvr\Backups\" & sDbName & "_db_" &
formatdatetime(now,1) & ".bak'" & _
" WITH INIT"

Conn.Execute _
"BACKUP LOG " & sDbName & _
" TO DISK='\\nassvr\Backups\" & sDbName & "_log_" &
formatdatetime(now,1) & ".bak'" & _
" "
If Err.Number = 0 Then
SendEmail sDbName,"SUCCESS",""
Else
SendEmail sDbName,"BACKUP FAILED " & Err.Number & "Desc: " &
Err.Description,""
End If
Err.Clear
On Error Goto 0
End Sub

Sub SendEmail(sDatabaseName,sMessage,sUploadFile)

'************************************************* *****
'*** Send the message Using CDOSYS Win2k & Win2003 ****
'************************************************* *****
' CDO mail object
myMailServer = sEmailServer

sch = "http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = CreateObject("CDO.Configuration")
cdoConfig.Fields.Item(sch & "sendusing") = 2
cdoConfig.Fields.Item(sch & "smtpserverport") = myRmailPort
cdoConfig.Fields.Item(sch & "smtpserver") = myMailServer
cdoConfig.fields.update

Set cdoMessage = CreateObject("CDO.Message")
Set cdoMessage.Configuration = cdoConfig
cdoMessage.From = sEmailAddFrom
cdoMessage.To = sEmailAddToo
cdoMessage.BCC = sConEmailMonitor
cdoMessage.Subject = "Backed up " & sDatabaseName & " on " &
formatdatetime(now,1)
cdoMessage.TextBody = "Backup " & sMessage & " of " & sDatabaseName & "
to \\NASSvr....."
If Trim(sUploadFile) <> "" Then
cdoMessage.AddAttachment "file://" & sUploadFile
End If
'
cdoMessage.item("http://schemas.microsoft.com/cdo/configuration/smtpauthenti
cate").value = 1 ' use clear text authenticate
'
cdoMessage.item("http://schemas.microsoft.com/cdo/configuration/sendpassword
").value ="mypassword"
'
cdoMessage.item("http://schemas.microsoft.com/cdo/configuration/sendusername
").value ="yourusername"
cdoMessage.Fields.Item("urn:schemas:mailheader:Key words") = ""
cdoMessage.Fields.Item("urn:schemas:mailheader:X-Priority") = 1
cdoMessage.Fields.Item("urn:schemas:mailheader:X-MSMail-Priority") =
"High"
cdoMessage.Fields.Item("urn:schemas:mailheader:X-Message-Flag") = "Do
not Forward"
cdoMessage.Fields.Item("urn:schemas:mailheader:Sen sitivity") =
"Company-Confidential"
cdoMessage.Fields.Item("urn:schemas:mailheader:Imp ortance") = "High"
cdoMessage.Fields.Update
cdoMessage.Send
Set cdoMessage = Nothing
Set cdoConfig = Nothing
End Sub







'****************************









"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1a8d681dddfed936989774@news-40.giganews.com...

> We have a client hosting a web site with Verio. It uses an SQL
> database.
>
> I can't FTP into the server to download the database, which means I have
> to connect to the server and pull all of the records down to do a
> backup.
>
> How do I do that? Can someone point me to a source for this procedure?
>
> Thanks!
>
> --Dave

[Manohar Kamath [MVP]]

Yes, just create a local database, and right click on the remote database
and do an "Import" and follow the wizard. Look up the SQL Server books
online for more help in this regard.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1a8edf973d8c9c52989775@news-40.giganews.com...

> In article <OwvxlRN7DHA.2412@TK2MSFTNGP09.phx.gbl>,
> [email]mkamath@TAKETHISOUTkamath.com[/email] says...

> > You could connect via enterprise manager (if verio gives you access) and
> > backup the database either locally (at the server) or transfer the data

to

> > your local machine. In either case, you need the IP of your SQL server,

and

> > the host should have enabled it on the Net.

>
> Verio has provided access to their server via Enterprise Manager. And I
> have SQL 2000 installed on my own personal server.
>
> So I can connect to Verio's server from Enterprise Manager and instruct
> it to send the data to my own server?
>
> --Dave