Good Morning

can some one point me in the direction of a good simple overview of back
stratagy
for sequal server. I'm running axapta, I run a full online backup
everynight, compress it, copy it to another server, reconnect just the mdb
file.

This works fine, but I would like to bring over the transcation file every x
minutes and apply it.

How and when does the transaction log get truncated, is it automatically
done for a full backup. we are actually doing two full backups of the data
base, will this work
or will I have incomplete transcation logs? because the second backup is not
copies across and restored because of day time band width restrictions?

Thnaks


David Hills




--
Thanks



David Hills

David,

First, I would point you to the SQL Books Online, the documentation which is
pretty thorough:
http://technet.microsoft.com/en-us/l.../ms187048.aspx -- Overall topic
http://technet.microsoft.com/en-us/l...9(SQL.90).aspx --
Strategies

From your comments, you might find the Log Shipping topic interesting as
well, though maybe it is more than you want to do.
http://technet.microsoft.com/en-us/l...3(SQL.90).aspx

RLF

"David Hills" <DavidHills (AT) discussions (DOT) microsoft.com> wrote

David Hills (DavidHills (AT) discussions (DOT) microsoft.com) writes:
The transaction log is truncated when you back up the log. When you back
up the database, nothing happens to the log. (Well, records of the backup
is written to it.)

If you are in simple recovery, the log gets truncated every now in then.
You need to use the full recovery model to be able to ship your logs.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx