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

error while importing text file into sql server 2000

hi all,

While importing into sql server 2000 from a text file i am getting an error message like not enough disk space available to perform this operation but there is enough space (around 18gb). Please advice why this is happenning as my work is stuck

thanks and regards

jk

This is a guess since you didn't give much detail, but try setting your BLOBTempStoragePath and BufferTempStoragePath properties to a location on the drive where this 18GB is available. These paths default to the drive where SSIS was installed, which is usually a system drive and may be close to full.
|||

thanks for the reply , could u please explane it in details as i am new to sql server 2000 the problem i am facing is that , when i try to import a text file into a DB it is showing ERROR 'not enough storage space.'

The text file is been exported from another DB using some date constrains. I have tried restoring DB just to check weather this is because of storage space problem but it works fine but when i try to import data the above error is shown . Please advice

thanks and regards

jk

|||This no longer sounds like a SQL Server 2005 Integration Services question. If it is, please provide details about your scenario and error. If not, you're probably best served by doing some web searches first and then posting your question in a more appropriate forum.