April 27, 2012 at 12:09 pm
We are running SQL server 2008 and are almost out of space on the drive where the Transaction logs are stored. IT has added another drive with more space. Can we simply change the default directory setting to point to the new drive and leave the original log files where they are and begin creating new log files on the new drive?
We use software that creates user databases for projects we use to collect data on telephone interviews. Each database has a very short life span so at the end of a project we will no longer use the database created for the telephone project. And after a while will delete the project which will free up space in the directory.
Thanks,
April 27, 2012 at 12:21 pm
paradski (4/27/2012)
We are running SQL server 2008 and are almost out of space on the drive where the Transaction logs are stored. IT has added another drive with more space. Can we simply change the default directory setting to point to the new drive and leave the original log files where they are and begin creating new log files on the new drive?We use software that creates user databases for projects we use to collect data on telephone interviews. Each database has a very short life span so at the end of a project we will no longer use the database created for the telephone project. And after a while will delete the project which will free up space in the directory.
Thanks,
if you mean the transaction logs for the new databases (yet to be created) then yes. just change the default directory and go from there. if you want to create a new log file on an existing database that gets a little tricky but can be done.
let us know which way you need to go.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 27, 2012 at 12:43 pm
Thanks for the reply
Yes, everything created on the new drive will be brand new log files (yet to be created). We don't want to do doing anything with the exisiting files. Just hoping we can change the drive for the new database without having to move existing files to the new drive.
April 27, 2012 at 12:45 pm
By modifying the log file directory wont create any issue. here is the steps.
April 27, 2012 at 5:59 pm
rraja (4/27/2012)
By modifying the log file directory wont create any issue. here is the steps.
from the OP's response it sounds as though existing databases are staying right where they are and only new DB's are moving to this new drive. you would not even have to change the default just make sure you specify the new location when creating the DB and every thing is all good.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
May 1, 2012 at 12:36 pm
Yes, that is it. The only hitch is that the software we use creates the projects by using the default settings so we will have to change that. And I assume there is no risk to the existing databases by doing that. Thank you for your help!
May 1, 2012 at 12:46 pm
paradski (5/1/2012)
Yes, that is it. The only hitch is that the software we use creates the projects by using the default settings so we will have to change that. And I assume there is no risk to the existing databases by doing that. Thank you for your help!
there should not be any risk but murphy has a history of rearing his head as the first mention of should not. i would take a fresh backup of the databases on the server and make your change.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply