SQL Server 2005
Thanks! We'll email you
when relevant content is
added and updated.
This is my first post and thanks in advance for any replies.
I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been,
"BackupMedium::ReportIoError: write failure on backup device '\server_namedb_dump.bak'. Operating system error 1398(There is a time and/or date difference between the client and server.)."
Also, on both occassions, the last Application event reported prior to the actual start of the backup job has been,
"The time stamp counter of CPU on scheduler id x is not synchronized with other CPUs."
The backup is between 2 different servers, one being a 16 processor 3.4Ghz Intel Xeon w/ 16G and a 16 processor 2.4Ghz Intel Xeon w/ 16G and both servers have the power scheme setting to always on. So, I don't think it's an issue with processors entering into a power saving mode by slowing down processor speed and possibly getting out of whack for this reason. But, I'm open to other inputs on this.
90% of the time this completely reliable... when it occurrs over the weekend and you come in on Monday it makes for an interesting Monday morning.
Again, thanks for any help,
February 23, 2009 7:54 PM
February 23, 2009 9:13 PM