My transaction log backup using the maintanance plan is failing with
following error message in the sql error log. Has anybody seen this before
and found a resolution. I have checked and ensured that the CPU has adquete
resources/memory to carry out the operation. Any suggestion would be higly
appreciated. Thanks
BackupIoRequest::WaitForIoCompletion: write failure on backup device
'\\epsql09sa\g$\backup\epsql12sa\sdn_reportingSQL12_log.bak'. Operating
system error 1450(Insufficient system resources exist to complete the
requested service.).b_dba wrote:
> My transaction log backup using the maintanance plan is failing with
> following error message in the sql error log. Has anybody seen this
> before and found a resolution. I have checked and ensured that the
> CPU has adquete resources/memory to carry out the operation. Any
> suggestion would be higly appreciated. Thanks
> BackupIoRequest::WaitForIoCompletion: write failure on backup device
> '\\epsql09sa\g$\backup\epsql12sa\sdn_reportingSQL12_log.bak'.
> Operating system error 1450(Insufficient system resources exist to
> complete the requested service.).
What SQL Version?
http://support.microsoft.com/kb/274310/EN-US/
http://sqljunkies.com/Forums/ShowPost.aspx?PostID=2835
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/cf17d0258c48bce0/c89a491b29c5611a?lnk=st&q=1450+%22Insufficient+system+resources+exist+to+complete+the+requested+service%22+%22sql+server%22&rnum=5&hl=en#c89a491b29c5611a
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Hello David,
Thanks for your input.
I am using SQL Server 2000 version. I checked on the links u mentioned but
did not find any info on resolving this issue. If you hav any other input,
let me know.
bishal
"David Gugick" wrote:
> b_dba wrote:
> > My transaction log backup using the maintanance plan is failing with
> > following error message in the sql error log. Has anybody seen this
> > before and found a resolution. I have checked and ensured that the
> > CPU has adquete resources/memory to carry out the operation. Any
> > suggestion would be higly appreciated. Thanks
> >
> > BackupIoRequest::WaitForIoCompletion: write failure on backup device
> > '\\epsql09sa\g$\backup\epsql12sa\sdn_reportingSQL12_log.bak'.
> > Operating system error 1450(Insufficient system resources exist to
> > complete the requested service.).
> What SQL Version?
> http://support.microsoft.com/kb/274310/EN-US/
> http://sqljunkies.com/Forums/ShowPost.aspx?PostID=2835
> http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/cf17d0258c48bce0/c89a491b29c5611a?lnk=st&q=1450+%22Insufficient+system+resources+exist+to+complete+the+requested+service%22+%22sql+server%22&rnum=5&hl=en#c89a491b29c5611a
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||U can check the follwing ling .It may help
http://forums.spywareinfo.com/lofiversion/index.php/t52631.html|||b_dba wrote:
> My transaction log backup using the maintanance plan is failing with
> following error message in the sql error log. Has anybody seen this before
> and found a resolution. I have checked and ensured that the CPU has adquete
> resources/memory to carry out the operation. Any suggestion would be higly
> appreciated. Thanks
> BackupIoRequest::WaitForIoCompletion: write failure on backup device
> '\\epsql09sa\g$\backup\epsql12sa\sdn_reportingSQL12_log.bak'. Operating
> system error 1450(Insufficient system resources exist to complete the
> requested service.).
Have you checked that the folder where you're placing the file exists?
Also make sure that you have sufficient disk space. What about
permissions to the folder? You need to have you SQL Server Agent running
under a Domain Account that has sufficient access to the folder.
Regards
Steen
No comments:
Post a Comment