Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JoeR
Starting Member
2 Posts |
 Posted - 2008-01-07 : 00:32:16
|
I have a database where we backup the database once a day and then copy the backup to tape. The log files are backup every hour to disk.In a disaster scenario ie failed server. We would take the tape backup and restore to another server but we need to apply the log files after the last backup. How can you only copy the last log file, with embedded date in the name, to another server  Cheers, JoeR |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2008-01-07 : 13:28:40
|
| "How can you only copy the last log file, with embedded date in the name, to another server.."I'm not sure if I quite get your question correctly, but basically if you have your full backups on tape, then you have to restore the last full backup from tape with norecovery option to the other server, then based on when you had your full backup, pick out all the tlog disk backups you have after the full backup, copy them to the other server, then restore them in sequence.Do you have your tlog backup files on individual disk files? Or you have them appended on a single file?Donn Policarpio |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-07 : 14:08:44
|
| You can't just copy the last log file as you won't be able to restore to a point in time with that unless the last log file is directly after the full backup. You need the entire transaction log chain after the full backup.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-07 : 16:10:36
|
also note that in sql server 2005 you can do this by using "copy only" when backing up the log.since you'll have to upgrade some time in the future anyway  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
JoeR
Starting Member
2 Posts |
Posted - 2008-01-07 : 17:54:54
|
| I have hourly individual log files after the daily backup. What I would like to do is copy the log files, as each one is created, to a File Server.Then recovery would be using the tape backup and log files (only the ones after the backup) from the File Server.Cheers, Joe |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 23:09:07
|
| Then you can either copy log backup files to tape, or backup log to remote file server directly. |
|
|
|
|
|
|
|
|
Copy Transaction log Files