Hi All,
I have acidentally installed SQL2005 with the data & logs writting to the same location, whereas I was wanting to put the transaction logs in a seperate folder. I have tried adding a new log file and removing the orginal through the properties window in the management console, but I get a message telling me that it cant remove primary file,but it is set to NA and not primary. I also tried downsizing it so that it's only 1 Mb and have the two log files there with the new one having a proper file size, but it will not let me shrink the file.
Hope someone can help, thanks in advance.
I have acidentally installed SQL2005 with the data & logs writting to the same location, whereas I was wanting to put the transaction logs in a seperate folder. I have tried adding a new log file and removing the orginal through the properties window in the management console, but I get a message telling me that it cant remove primary file,but it is set to NA and not primary. I also tried downsizing it so that it's only 1 Mb and have the two log files there with the new one having a proper file size, but it will not let me shrink the file.
Hope someone can help, thanks in advance.