Backup up Transaction logs

Question

Is it possible copy the physical Transaction log file for SQL 2005?

Currently our databases are backed up every night with hourly Transaction logs taken during the day. Is it possible that after the hourly backup has been done that the physical log file can be copied to another server? what steps would need to be taken to get this to work

Thanks

Andrew

Answer 1

To copy to another Sql Server? If so, what you are after is transaction log shipping

The transaction log backup captures the log at a certain point in time, however the log is still required to give the complete picture of the data in the database so it can't be moved. If you want to move it, stop any applications that are accessing the database's data, take the database offline, detach it, move the files and re-attach it.

Answer 2

What Chris said. If you're asking whether it's a space problem, you'll need to take transaction log backups more often. Don't shrink the transaction logs, because they'll just grow again.