SQL Backup and Sharepoint Backups Clashing

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 2008 Forums

SQL Server Administration (2008)

SQL Backup and Sharepoint Backups Clashing

Author

Topic

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2011-10-24 : 10:23:16

Has anybody faced clashing of SQL Native and Sharepoint backups ?
We have a server where we have tweaked around the backup timings but they don't always finish gracefully and then the server becomes unresponsive thereafter. It is a Windows 2003/SQL2008 box. PRetty solid memory/CPUs.

Regards
Paresh Motiwala
Boston, USA

kstjacques
Starting Member

8 Posts

Posted - 2011-10-24 : 22:01:45

Do you happen to have specific backup errors from the log that you could share?

Thanks,
Kim

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2011-10-25 : 14:21:14

hmmm..what I have seems to point to Sharepoint backup dying, and then hell breaks lose.

example:
Message
BackupIoRequest::ReportIoError: write failure on backup device 'dab1d23a-4221-43ea-9a5b-c419ba902570'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

BACKUP failed to complete the command BACKUP DATABASE WSS_Content. Check the backup application log for detailed messages.

Message
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'dab1d23a-4221-43ea-9a5b-c419ba902570'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Regards
Paresh Motiwala
Boston, USA

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2011-10-25 : 14:25:23

and soem more
SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.
. Process=2228. Thread=5640. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_457D120A-7656-4B2B-865C-CF3851D66F2C_SQLVDIMemoryName_0.

Cannot open backup device 'SQLBACKUP_457D120A-7656-4B2B-865C-CF3851D66F2C'. Operating system error 0x80070002(The system cannot find the file specified.).

BACKUP failed to complete the command BACKUP DATABASE RM_Cache_CF2BEBF5. Check the backup application log for detailed messages.

The issue is, this doesn't always happen.

Regards
Paresh Motiwala
Boston, USA

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2012-03-21 : 10:30:24

We had to involve Microsoft. They found that the NTP (part of Symantec) ran some KErnel Mode TSR, that treated multiple files copying as a Network intrusion and shut it off.
3 months, it took to figure it out.

Regards
Paresh Motiwala
Boston, USA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources