SQL Server Space

[rc@die@you@!spammers.sandworm.demon.co.uk]

I have a SQL server that is running out of log space.
I have several NAS box availabe to with lots of space, is there any I
can use maped drive to store the logs in.

I am not too concrned with speed

[Ray Higdon]

Re: SQL Server Space

You can add additional log files as needed, just curious if you are
periodically backing them up or if the growth process is normal. To add
files

from BOL:

ALTER DATABASE dbname
ADD LOG FILE
( NAME = test1log2,
FILENAME = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Da ta\test2log.ldf ',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB),
( NAME = test1log3,
FILENAME = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Da ta\test3log.ldf ',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
GO



Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!