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.
9  1804 
sql guy123 (st*****@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, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
How can I learn to do this? Is there a chance for data corruption?
thank you
Does any one have a good source to accomplish this?
thanks
I've heard of books online, but where is it, what is it? Is it a
website? What is the web address.
thank you
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
I have over 5000 thumbnail pictures of size 5kb each. I would like to
able to load all 5000 pictures and view 50 per page using
mysql_data_seek(). I would like to know what are the advantages and...
|
by: Tony Fibannaci |
last post by:
I have two db's. One on a local server, one on a remote server. Both
are running MySQL 4.0. The remote is a production server that I run
mysqldump on nightly to backup the prod data. The local...
|
by: someguy |
last post by:
Hi,
We are going to be running two SQL Server 2000's from the same
physical server, with Windows Server 2003, and I need to have certain
tables between them syncronized. Database A is a backend...
|
by: swoozie |
last post by:
This may not be a MSSQL-specific question, but
I wanted to ask it here first, in case there's
a MSSQL and/or SourceSafe solution that will help.
Our dev team is having some difficulty with...
|
by: Ron Johnson |
last post by:
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote:
> One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database.
>
>...
|
by: M.L. |
last post by:
Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover...
The two nodes are perfectly identical (same os, users, and db2 setup
(instances, db, tables...)).
<----...
|
by: DKode |
last post by:
I am preparing to build an app that will pull data from multiple
databases on the same sql server.
For performance sake, is there a more "effecient" way to grab data from
multiple databases at...
|
by: Vinciz |
last post by:
hi guys... im new in java and i would love to learn some of these...
basically i got a sample code to retrieve the blob from the mysql.
however, i dont really know what to do with these...
|
by: morleyc |
last post by:
Hi, until recently i was quite happy to add data sources from mssql
database in visual studio and drag the datasets directly onto the form
this creating a directly editable form which worked well....
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
