Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karabela
Starting Member
2 Posts |
 Posted - 2005-05-20 : 05:44:17
|
| i installed ms sql. i installed program to harddisk C and the data of sql on harddisk F. i also have harddisk E which was reserved for the log files of sql. how can i configure it. at installation i didnt had the choice for a different place for the log files. only for the program files and the data files i had the choice. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-20 : 07:53:27
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;224071MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
karabela
Starting Member
2 Posts |
Posted - 2005-05-23 : 09:05:54
|
| i dont want to move the dabase. i want to move the logs. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-23 : 09:37:52
|
| The database log files or the error log files? If you want to move the database log files, then follow the directions in the article only moving the log files instead of both data AND log files. If you want to move the error log files, then you need to follow this:1. Right-click on the SQL Server in Enterprise Manager and select Properties.2. Click the Startup Parameters button.3. You will need to specify a new location for the error log files using "-eC:\newdirectory\ErrorLog4. You will need to remove the old entry.5. You will need to restart SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
log