Is there a way that I can specify a different default drive location
for the tran log? I would like the user to not have to specify the
tran log when he creates a database. I want the tran log to be on a
different physical file.
right click on the sqlserver | properties|and check the database settings
> Is there a way that I can specify a different default drive location
> for the tran log? I would like the user to not have to specify the
> tran log when he creates a database. I want the tran log to be on a
> different physical file.
Thats a server side one time setting.Once the default path is set, all those
databases created after that will follow the new path for transaction log.
would do something in model that would propagate to all new databases.Quote:
> Hello to you too ;-)
> Yeah I know...but if there is a way to avoid that step, similar to how one
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
I'm hoping there is a way to do this. I've been given the task of moving
the physical location of the tran log file for several of our databases.
Currently, the log file is on the F: drive, I need to move it to the E:
drive. When I go into the database properties and try to move the files on
our test database, I'm told that they can't be moved after the initial
Does anyone know of a way to move the log files from one partition to
Thanks in advance for your help.