[thelist] SQL Server Backups

[Maximillian Schwanekamp]

>See if you ISP will do a nightly backup of your DB to a directory just off
>your web root. Then you can grab it and store it yourself off site.

Good suggestion.  Unfortunately they require $10 per backup to do that
(unreasonable, yes!), which would add up quickly over time.

>If you have MS SQL internally you could setup a DTS transaction that goes
>and gets the DB exports it your local DB. (Of course your ISP will have to
>allow remote connections to the hosted DB).

This would be a good idea too, except that my install of SQL Server is only
an eval copy (for this very purpose), with a time limit on it.  Also, my
workstation is a laptop, which is not always connected while I work.  I
would like to remove the thing anyway, as I am neither inclined nor
qualified to maintain the security patches and such for SQL Server on my own
machine.

Maximillian Von Schwanekamp
Enabling microbusiness and infopreneurs
NeptuneWebworks.com :: InfoMarketingInsider.net
voice: 541-302-1438
fax: 208-730-6504


-----Original Message-----
From: Anthony Baratta [mailto:anthony at baratta.com]
Sent: Friday, February 20, 2004 5:53 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] SQL Server Backups


At 05:38 PM 2/20/2004, Maximillian Schwanekamp wrote:
>Anybody have any suggestions for backing up a remote shared-host SQL Server
>database?

See if you ISP will do a nightly backup of your DB to a directory just off
your web root. Then you can grab it and store it yourself off site.

If you have MS SQL internally you could setup a DTS transaction that goes
and gets the DB exports it your local DB. (Of course your ISP will have to
allow remote connections to the hosted DB).


---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !