Error:Disable database user Failed :The Log for database ‘XXXXX’ is not available.Check the event log for related error messages.Resolve any errors and restart the database.(Error code 1)
Description:
In plesk control panel while unsuspend domain it is giving the below error.Database log file is not connecting to the specified database.
Error:Disable database user Failed :The Log for database ‘XXXXX’ is not available.Check the event log for related error messages.Resolve any errors and restart the database.(Error code 1)
Solution:
– Login to the server with Administrator details.
– Now open SQL server Management Studio and expand the databases.
– Choose the database which is giving the log error and right click on the database select properties.
– In properties window select files option at right hand side.Click on Add and give the new file name like DBname_logfile.set the file type Log and Initial size is 10mb.
– Now Select Options and set Recovery model to simple.And in second options Automatic and set Auto Shirnk to True.
– Before Apply the changes take the back of log files and complete database.
– Now Apply the changes.
Add Comment