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 |
|
maranbe
Starting Member
28 Posts |
 Posted - 2006-10-17 : 06:29:08
|
Hi folks,Here's the scenario:1. 12:00 AM - Full or Diff backup2. every 15 minutes t-logs backup (logs are stored to the recent backup file of either the full or diff)3. after the full or diff backup our network guy backup the files from the disk to tapeWhile doing the backup from disk to tape, the file being backup is also being updated via the tlogs backup. What will happen to the file that is being backup on to tape while also the same file being used to store the t-logs backup Hope others could shed light and share their approaches in backing up db files backup to tape.Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
maranbe
Starting Member
28 Posts |
Posted - 2006-10-18 : 01:39:17
|
| Thanks NR. I guess my problem now is how to backup t-logs files to tape without losing t-logs due to locking of files.Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-21 : 10:44:35
|
| You could backup to one folder and then MOVE to another folder to backup. The standard Command Line MOVE will not move a file that is open - so that one will get moved on the next hourly run, etc.Kristen |
|
|
|
|
|
|
Disk to tape backup