SQL Server Space

[rc]

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]

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\Data\test2log.ldf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB),
( NAME = test1log3,
FILENAME = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\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!