|
Home > Archive > MS SQL Server > December 2006 > Re: What type of replication should i use? --none
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: What type of replication should i use? --none
|
|
| Kevin3NF 2006-12-05, 7:12 pm |
| backup the database and compress the .bak file. Stick it on an FTP site and
let them pull it.
For this situation, replication introduces complexity you don't need.
If you want to be really efficient, get SQL Backup or Litespeed for you and
the external vendor and send them a compressed and encrypted copy.
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
<stuckish@gmail.com> wrote in message
news:1165327696.060262.219930@79g2000cws.googlegroups.com...
> We need to provide a external company with a copy of our database on a
> regular basis, probably about once every night. Our database is a SQL
> Server 2005 Ent edition and we assume the external company will use the
> same ..
>
> I have looked around and realized that there is a lot of alternatives.
> I can state some facts and some requirements ..
>
> 1. The data do not need to be up-to-date, once per night is ok.
> 2. The database is rather big ~5-10 (depend on log size) gb and i think
> it will grow ..
> 3. Performance on the server is not a big issue since the system is
> usally down during nights.
> 4. I think we have ok (~10mbit) bandwidth between us and the external
> company ..
>
> As i can see it it seems like Snapshot replication is the best way to
> go in our scenario where we need a as fast system as possible during
> work hours but do not care at all during night.
>
> Anyone have any suggestions?
>
| |
| Tracy McKibben 2006-12-05, 7:12 pm |
| Kevin3NF wrote:
> backup the database and compress the .bak file. Stick it on an FTP site and
> let them pull it.
>
> For this situation, replication introduces complexity you don't need.
>
> If you want to be really efficient, get SQL Backup or Litespeed for you and
> the external vendor and send them a compressed and encrypted copy.
>
I agree, send them a backup. You could even just zip the BAK file
before sending it to them, SQL backups zip up REALLY well.
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|
|
|
|
|