2005 install - Can you specify a directory for the data and one for the logs?

Hi,
I am setting up a template.ini file that I am going to use for some
unattended installs of SQL Server 2005. I believe using the
'INSTALLSQLDATADIR' I can get the system databases setup with their
data files and log in the directory I specify. Is there a way to
specify a location for the logs and a location for the data files?I don't think so. There is really not much a need for that either.
Linchi
"Paul T." wrote:
> Hi,
> I am setting up a template.ini file that I am going to use for some
> unattended installs of SQL Server 2005. I believe using the
> 'INSTALLSQLDATADIR' I can get the system databases setup with their
> data files and log in the directory I specify. Is there a way to
> specify a location for the logs and a location for the data files?
>|||Most people split their user databases so that the log is on one
physical drive and the logs are on another so that I/O is distributed
and so that if they do not lose both the log and data file if a drive
goes, why not do that with the system databases too?|||Paul T. wrote:
> Most people split their user databases so that the log is on one
> physical drive and the logs are on another so that I/O is distributed
> and so that if they do not lose both the log and data file if a drive
> goes, why not do that with the system databases too?
>
Your system tables should have very little I/O against them, and good
backups will protect you from losing them...
Tracy McKibben
MCDBA
http://www.realsqlguy.com

2005 Directory Tree

I am look to maintain a directory tree table in SQL Server 2005. The table
will contain details of file and folder paths, titles, size and a few other
additional fields not related to the file system.
Before I begin, and start writing code to maintain the table is there
anything in 2005 which could do most of the work for me? For example, the
file system be watched for changes and update the table automatically, i.e.
files or folders added, changed or deleted.
I keep hearing about all the fantastic new features in 2005, I would be
really impressed if it means I don't need to do any work for this.
Any help would be greatly appreciated.
DavidHi
There are no new functions in SQL 2k5 that can do this. Unfortunately SQL
Server is not build for file handling. I guess thats the only functionality
that Microsoft has missed out from that :)
--
"Davie" wrote:

> I am look to maintain a directory tree table in SQL Server 2005. The tabl
e
> will contain details of file and folder paths, titles, size and a few othe
r
> additional fields not related to the file system.
> Before I begin, and start writing code to maintain the table is there
> anything in 2005 which could do most of the work for me? For example, the
> file system be watched for changes and update the table automatically, i.e
.
> files or folders added, changed or deleted.
> I keep hearing about all the fantastic new features in 2005, I would be
> really impressed if it means I don't need to do any work for this.
> Any help would be greatly appreciated.
> David
>
>|||I am sure I read a while ago, think it was prior to release, Notification
Services can have a file system watch event?
"Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
news:7EDC42CB-A6C5-4B25-960F-9065284E6C8E@.microsoft.com...
> Hi
> There are no new functions in SQL 2k5 that can do this. Unfortunately
> SQL
> Server is not build for file handling. I guess thats the only
> functionality
> that Microsoft has missed out from that :)
> --
>
>
> "Davie" wrote:
>|||I am not sure about that. Sorry about the wrong info if one exists.
--
"Davie" wrote:

> I am sure I read a while ago, think it was prior to release, Notification
> Services can have a file system watch event?
>
> "Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
> news:7EDC42CB-A6C5-4B25-960F-9065284E6C8E@.microsoft.com...
>
>