Friday, February 24, 2012

Error while taking the backup

Error while taking the backup....
I used the following command
backup database test to disk = 'e:\bktest05172005'
"e:" is basically a map drive.
Error :
Windows - Delayed Write Failed
Windows was unable to save all the data for the file
\Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
lost. This error may be caused by a failure of your computer hardware or
network connection. Please try to save this file elsewhere.
OK
Any idea ?
Thanks
Hi
Do not use mapped drives. Only use UNC paths.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Joh" <joh@.mailcity.com> wrote in message
news:uwslpuwWFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Error while taking the backup....
> I used the following command
> backup database test to disk = 'e:\bktest05172005'
> "e:" is basically a map drive.
> Error :
> --
> Windows - Delayed Write Failed
> --
> Windows was unable to save all the data for the file
> \Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
> lost. This error may be caused by a failure of your computer hardware or
> network connection. Please try to save this file elsewhere.
> --
> OK
> --
> Any idea ?
> Thanks
>
>
|||There is a way to use mapped drives, but its not recommended, even not from
me ;-)
If the Agent uses a mapped drive to backup the database on it, a logon
script has to be defined for that service account mapping the drive for it.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:uwslpuwWFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Error while taking the backup....
> I used the following command
> backup database test to disk = 'e:\bktest05172005'
> "e:" is basically a map drive.
> Error :
> --
> Windows - Delayed Write Failed
> --
> Windows was unable to save all the data for the file
> \Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
> lost. This error may be caused by a failure of your computer hardware or
> network connection. Please try to save this file elsewhere.
> --
> OK
> --
> Any idea ?
> Thanks
>
>

No comments:

Post a Comment