[posted and mailed, please reply in news]
jaekim (jk****@socal.r r.com) writes:
I am wondering if it is a good idea to replicate sql server db files
using frs.
I don't really know how the frs works, so
does frs replicates the whole database from time to time or just the
portion that is changed?
Also if the db is expected to change very often, and wouldn't it make
the whole system down?
I wonder if it's a good idea just to make a backup of the database and
copy it.
What's the usual practice?
I'm uncertain of what your question actually is, and whatever I have never
heard of frs.
You talk about replication, but your question seems to be about backup.
Replication and backup are two quite different things.
To backup a database, you use the BACKUP command in T-SQL. There are three
ways to back up a database:
* Full backup, backup the entire database.
* Differential backup, back up the changes since the last full backup.
* Log backup, backs up the *transaction log*.
Normally you use both Full backup and Log backup. By backing up the
transaction log, you can get up-to-the-minute recovery in case of a
crash (which could be a fatal human error).
To be able to backup the transaction log you must run in Full or Bulk-logged
recovery mode. On the other hand, if you run in these modes, you must
backup the transaction log, or the log will eventually fill your disk.
It is important to understand that SQL's BACKUP command knows about
transactions, and thus you can backup the database while there is
activity in it. If you would just copy the database files outside SQL
Server, you might get a useless set of bytes on the tape.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp