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/
1
hismightiness
10/1/2004 2:17:44 PM
📁 asp.net.sql-datasource
📃 29906 articles.
⭐ 0 followers.

💬 2 Replies
👁️‍🗨️ 1138 Views

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/
-1
mbanavige
10/2/2004 9:43:36 PM
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.
1
KraGiE
10/2/2004 10:43:07 PM
Reply: