Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

log shipping error with tuf file

Status
Not open for further replies.

TWillard

Programmer
Apr 26, 2001
263
US
I am using log shipping via database maintence plans within SQL 2000 environment. The copy job and restore job are failing on my secondary server. The average size of the log shipped trn files is approximately 1 - 3 mb. Once a week, we rebuild the indexes and a 3 or 4 gig trn file will get log shipped over. Today we implemented some archiving within the database, simply moving records around within the same database and filesystem to history tables. This created a one time 4 gig trn file. This file was successfully copied over, but now the restore jobs and copy jobs are failing. The odd part is that there is tuf file in the tran log directory. What is a tuf file and why did sql server create it?
 
continued....

In the log shipping monitor the first error states copy error Failure / 32 The process can not access the file because it is being used by another process.

In the event log, it is listed as EventID 17055 18204 :
BackupDiskFile::OpenMedia: Backup device 'L:\MSSQL\Backup\DBName\DBName_tlog_200603272142.TRN' failed to open. Operating system error = 32(The process cannot access the file because it is being used by another process.).

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top