I have been unsuccessful in adjusting the memory that sql server uses. I
have changed the setting in the properties but it did not work.
I saw that it didn't work in the log and I tested it with some real bad
SQL's and it did not use the additional memory.
?????????????????????
-Kevin
-----Original Message-----
From: Mark.[Email Address Removed] Wednesday, February 27, 2002 11:58 AM
To: Sexton, Kevin; [Email Address Removed] RE: backup error
Do you have any free space - looks like an out of space error to me. Try
switching on perfmon and do the backup again, monitoring your disk space
and
CPU and memory. It could also be an out-of-memory error - make sure the
OS
has enough memory by checking the dynamic memory setting. Give the OS
100-200Mb if you have over 500Mb in your box.
Mark.
www.allisonmitchell.com
-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] 27 February 2002 16:43
To: [Email Address Removed] backup error
I received this error when trying to run a scheduled backup from one
server to another. It did create a large . BAK file but not complete.
BackupMedium::ReportIoError: write failure on backup device
'\\testbed2\f$\REGEN_REPORT_IVbkup'. Operating system error
1450(Insufficient system resources exist to complete the requested
service.).
-Kevin
---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message and any attachment are confidential and may be privileged
or otherwise protected from disclosure. If you are not the intended
recipient, please telephone or email the sender and delete this message
and any attachment from your system. If you are not the intended
recipient you must not copy this message or attachment or disclose the
contents to any other person.
For further information about Clifford Chance please see our website at
http://www.cliffordchance.com or refer to any Clifford Chance office.
MS Sql Server LazyDBA home page