- Can the file be deleted/ truncated? Do I have the same from the server perspective data in my DB log?
- Is it normal to have a 3GB sdedc_SQL Server.log file?
- How can it be moved to another drive?
- Will AGS performance be affected if I move the folder to and allocated storage (rather than a local HD)?
The file is a log for direct connections made to your SQL Server geodatabase. The path you specified is the default location; every OS user account will have one if a direct connection is made while the OS user account is logged into the machine. I'm not sure if you would be able to change the location of the file other than modifying the TEMP and/or TMP user variables or removing those user variables and modifying them at the system variable level. Moreover, I'm not sure why you would want to change the output path for this file. You're welcome to move it or delete it or truncate it; but it will be re-created and written to each time a direct connection is established. AGS performance shouldn't have anything to do with the location of this file.