Kevin,

OK - yes they are the same thing. :-)

Right-click your server in Enterprise Manager and select Properties. Select
Memory tab. If using dynamic memory slide the bottom slider to the left a
little so that you give the OS a bit more memory to play with - I usually
give at least 128Mb if there are no other apps on the box. SQL Server is
good at doing a memory land-grab and doesn't like to give it back when asked
to by the OS.

If using static memory do the same thing.

As for /pae and /3gb see this article:

Q274750 HOW TO: Configure SQL Server Memory for More Than 2 GB,
http://support.microsoft.com/support/kb/articles/q274/7/50.asp

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] 28 February 2002 13:50
To: Mark.[Email Address Removed] RE: backup error


Please forgive me. I thought memory and RAM where the same thing. Can
you explain the difference?
I know what the boot.ini file is but I don't understand your reference
to "/pae and /3gb".
Thankyou,
-Kevin

-----Original Message-----
From: Mark.[Email Address Removed] Thursday, February 28, 2002 7:50 AM
To: Sexton, Kevin
Subject: RE: backup error


My question was how much memory have you allocated to SQL Server? Not
how
much RAM you've got.

As for using 8Gb you need to set both /pae and /3gb in the boot.ini
file.
This applies to WIn2000 Advanced Server - are you using this?

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] 28 February 2002 12:13
To: Long, Charles (euler:eti)
Cc: [Email Address Removed] RE: backup error


We have 8 GB of memory on that machine. We have not been able to get it
to use any more than the default 1.7 GB though (that's a separate
issue...let me know if you know the answer to that one as well)

-Kevin

-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Thursday, February 28, 2002 3:33 AM
To: Sexton, Kevin
Subject: RE: backup error


I see Mark suggested 'out of memory ' could generate that error?

> -----Original Message-----
> From: Sexton, Kevin [SMTP:kevin.[Email Address Removed] Sent: Wednesday, February 27, 2002 6:25 PM
> To: Long, Charles (euler:eti)
> Subject: RE: backup error
>
> I have 500 GB of disk space. that is not the problem.
>
> -K
>
> -----Original Message-----
> From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Sent: Wednesday, February 27, 2002 11:57 AM
> To: Sexton, Kevin
> Subject: RE: backup error
>
>
> You'll get this with Oracle as well - probably with slightly differing
> presentation; it's the antique there needs to be more disk than file
> problem.
>
> > -----Original Message-----
> > From: Sexton, Kevin [SMTP:kevin.[Email Address Removed] > Sent: Wednesday, February 27, 2002 4:43 PM
> > To: [Email Address Removed] > Subject: 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] > For additional commands, e-mail: mssqldba-[Email Address Removed] 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