cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New

Clean SQL server log file

Ok, so as always - Support Chat is not available, maybe I can find some help here.

I need to clean up my SQL Server LOG file, there is no auto-cleanup during back up action.

 And no permission to execute DBCC SHRINKFILE

 

SELECT file_id, name, type_desc, physical_name, size, max_size  
FROM sys.database_files ;
 
1Colecty_1ROWSE:\MSSQL.MSSQLSERVER\DATA\Colecty_1.mdf2549625600
2Colecty_1_logLOGD:\MSSQL.MSSQLSERVER\DATA\Colecty_1_log.ldf1280012800
4 REPLIES 4
New

Re: Clean SQL server log file

And no permission to execute DBCC SHRINKFILE

New

Re: Clean SQL server log file

Any help?

Re: Clean SQL server log file

I have same problem, any idea?

Community Manager
Community Manager

Re: Clean SQL server log file

Hi @inferno. If you need to have your log file cleaned, our hosting support would need to do this for you.  Find out more about contacting support here. Hope that helps. 

 

JesseW - GoDaddy | Community Manager | 24/7 support available at x.co/247support | Remember to choose a solution and give kudos.