SQL Server 2005 SP2 backup failing

10 pts.
Tags:
SQL Server 2005
SQL Server 2005 SP2
SQL Server backup
SQL Server backup and restore
SQL Server database
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, Andy

Answer Wiki

Thanks. We'll let you know when a new response is added.

Within a Windows domain the time on the machines has to be within a couple of minutes of each other. If one of the computers is drifting its time you’ll have problems talking between the machines. It is recommended that domains use the time sync features of the computers to ensure that the times match between all the machines.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following