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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 tlog backup failure due to time difference

Author  Topic 

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-04-03 : 19:53:07
I run transaction log backups every 30 minutes between 8AM and 5PM. However between 4 and 5 PM, the transaction log backup almost always fails due to the error below. I am backing up across a SAN to a NAS device.

BackupDiskFile::CreateMedia: Backup device '\\MyNAS\sql\apps\MyDB_tlog_200501151700.TRN' failed to create. Operating system error = 1398(There is a time difference between the client and server.).

How do I troubleshoot this?

Thanks,
Ray

nr
SQLTeam MVY

12543 Posts

Posted - 2005-04-03 : 20:19:51
see
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=2401

Are you using maint plans? What happens if you don't.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-04-11 : 13:16:42
I am using maintenance plans right now. Sorry I didn't a chance to test w/o them. Our network admin synchronized the time between the SQL server and the NAS device and all seems well.
Go to Top of Page
   

- Advertisement -