Solved

SQL Backup failing with delayed Write Failed message.

Posted on 2007-03-22
2
324 Views
Last Modified: 2012-06-21
Hi, I'm having trouble backing up 2 SQL 2000 Dbs to a network drive, I'm using the following

BACKUP DATABASE Database
TO DISK = '\\server\e\backups\Sql backups\database.bak';
   
GO

They start writing fine, but they seem to always fail with

"Delayed Write Failed} Windows was unable to save all the data for the file \Device\LanmanRedirector."

I can find reg edits and patches for other OS other than 2003 which I am using, the detination location is on a 2003 R2 Windows Storage Server.

Any help would be great.
0
Comment
Question by:edwalters
2 Comments
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 500 total points
ID: 18772689
as I understand, you saw http://support.microsoft.com/default.aspx?kbid=321733 ; still I would try at least the reg edit. XP is pretty much the same thing as server 2003.
0
 
LVL 1

Author Comment

by:edwalters
ID: 18772759
II did have a look at that and in my 2003 server that setting is already applied, at least I am fairly sure it is.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now