Database connection options for log files (ldf)

[diegohb]

I was wondering if there was an option in the connection settings (DbConfig) to set the path to the database log file. Also, max growth setting for log file.

 

I've set the DatabasePath setting which tells plastic where to place database data files and it also puts log files (ldf) in the same directory.. Would there be a problem with running a weekly job that checks for log files configured to the DatabasePath and moves them to a different directory? 

 

Our sql server is setup as follows:

 

..\mssql\data\*.mdf/*.plastic

..\mssql\log\*.ldf

 

[calbzam]

Hi,

 

Plastic db.conf can´t manage SQLServer log files, but I have found some articles you will probably like:

 

- How to move .ldf files to different locations: http://www.soheib.com/technical-knowledge/move-database-files-mdf-ldf-to-different-physical-location/

- Shrinking SQL Server log files: http://databases.about.com/od/sqlserver/a/truncate_shrink.htm   ,   http://stackoverflow.com/questions/40402/what-is-the-command-to-truncate-a-sql-server-log-file

 

Regards,

Carlos

[diegohb]

thank you for the response! I have a dedicated mssql instance for pscm.. so i'm going to schedule a job that does something like 
 

 

EXEC sp_MSforeachdb

'IF N''?'' NOT IN(''model'' ,''master'', ''msdb'', ''tempdb'', ''teamcity7'')

BEGIN

SELECT ''RESTORE DATABASE ? FROM DISK = ''''E:\MSSQL\2012\MSSQL11.PSCM\Backup\?.bak'''' 

WITH FILE = 1,

MOVE ''''?'''' TO ''''E:\MSSQL\2012\MSSQL11.PSCM\Data\?.plastic'''',

MOVE ''''?_log'''' TO ''''E:\MSSQL\2012\MSSQL11.PSCM\Log\?.plastic.log'''', STATS = 5

GO''

END'

 

 

except not restore... this is what i used to move databases from one server to another... instead i'll use alter database modify file

[calbzam]

Interesting article too, Thanks!