• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 810
  • Last Modified:

Adding MemToLeave -g Switch

[Sql Server 2005 SP-2]

Can I get some help with just the syntax of adding the -g switch to define CLR memory allocation?

The last bit of text in my startup parameters is the ".ldf" file.  So I tried adding a space and the switch (so, "...ldf -g512") and I've tried no space ("...ldf-g512").  I can't start sql with either syntax.

The event log says:

FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf-g512 for file number 2.  OS error: 2(The system cannot find the file specified.).

Where, exactly, do I put this switch, and what should it look like, exactly?  I'm not getting this right, and I'm doing this on a production box (no, not by choice) so I can't keep stopping and starting sql.

Thanks.
0
bamapie
Asked:
bamapie
1 Solution
 
nmcdermaidCommented:
Looking in SQL Server Configurtaion Manager (Start Menu/SQL Server/Configuration Tools/SQL Server Services/SQL Server/Properties/Advanced/Startup Parameters), my parameters look like this:
 -dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Following the same format I expect that you need to do this:
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;g1024
assuming you want to set g to 1024.
0
 
bamapieAuthor Commented:
Looks good to me.  I'm too chicken to try it right now, but I will.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now