|
Home > Archive > Microsoft SQL Server forum > December 2005 > Sync to databases nightly with BLOB data
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 |
Sync to databases nightly with BLOB data
|
|
| sql guy123 2005-12-10, 3:23 am |
| I need some assistence here.
I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS
desktop engine).
I need to sync my databases nightly, as a backup.
Is there a cheap software that will do this? I don't want to just
backup the entire databases files b/c they are large and I'm
transfering them over DSL.
I was thinking transaction logging, but I'm not sure. Is there a easy
way to do this?
I don't know how to accomplish this task.
PLEASE HELP.
| |
| Erland Sommarskog 2005-12-10, 7:23 am |
| sql guy123 (stoppal@hotmail.com) writes:
> I need some assistence here.
>
> I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS
> desktop engine).
>
> I need to sync my databases nightly, as a backup.
>
> Is there a cheap software that will do this? I don't want to just
> backup the entire databases files b/c they are large and I'm
> transfering them over DSL.
>
> I was thinking transaction logging, but I'm not sure. Is there a easy
> way to do this?
You could indeed back up the transaction log, bring that over the network,
and then apply that log on the other database.
The catch here is that you must run with full or bulk_logged recovery, and
you must never truncate the log on the source server. If you do so, you
will need to bring a full backup over the net at this point.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
| sql guy123 2005-12-12, 9:23 am |
| How can I learn to do this? Is there a chance for data corruption?
thank you
| |
| sql guy123 2005-12-12, 1:23 pm |
| Does any one have a good source to accomplish this?
thanks
| |
|
|
| sql guy123 2005-12-12, 8:25 pm |
| I've heard of books online, but where is it, what is it? Is it a
website? What is the web address.
thank you
| |
|
|
| sql guy123 2005-12-14, 8:25 pm |
| I see, but once I get to the webpage and try to download the file, it
states it's unavailable. No worries, I track it down.
Thank you.
| |
| Erland Sommarskog 2005-12-14, 8:25 pm |
| sql guy123 (stoppal@hotmail.com) writes:
> I see, but once I get to the webpage and try to download the file, it
> states it's unavailable. No worries, I track it down.
That's bad. I will alert some people. I the mean time, check out the SQL
Server program group from the Start button.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
| sql guy123 2005-12-15, 1:23 pm |
| ok
thanks
|
|
|
|
|