Transaction Log Files/Virtual Log Files

I am wanting to reduce the amount of Virtual Log Files I have.  In reading through the Online Book Documentation, I realize that I have forgotten to move the Transaction Log Files to a different drive.  Now that the server is in production, I wanted to get some input about the best way of making this change.  


Can I just change the directory the log files are being written to in the DB properties without having any adverse problems occurring?
Will

http://www.strohlsitedesign.com/
http://www.WillStrohl.com/

changing the logfile location is probably going to require to to get single user access to the db which means your going to have to boot everybody out for a few minutes
Mike Banavige
~~~~~~~~~~~~
Need a site code sample in a different language?  Try converting it with:  http://converter.telerik.com/

hismightiness,


you're in for a world of hurt.  you have to turn off that production database for a few minutes like what the other dood said, and re-adjust the database.  There's no way to do it while processing.  :(


DBCC SHRINKDATABASE 


    ( database_name [ , target_percent ] 


        [ , { NOTRUNCATE | TRUNCATEONLY } ] 


    )


DBCC SHRINKDATABASE (UserDB, 10)


that'll give you some space if needed, but make sure you use it prior to moving things around.  on a business purpose, the longer that server's down, the more trouble you'll get into.  :)

Kay Lee
MySpace.com - http://www.myspace.com/kragie
Infrastructure Group
MySpace.com

- Code to live, but Live to code.