0

I am trying to configure Management Data Warehouse Wizard from SSMS for Data collection.

Getting error message at step2: Run Installation Script on Database.

Error message info in below:

Run installation script on DB_Name (Error)

Messages:

Failed to configure data collection

------------------------------
ADDITIONAL INFORMATION:

The transaction log for database 'msdb' is full due to 'ACTIVE_TRANSACTION'. (Microsoft SQL Server, Error: 9002)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=13.00.1601&EvtSrc=MSSQLServer&EvtID=9002&LinkId=20476

Warning: Database created by the wizard is not cleaned up after failure. 

------------------------------
ADDITIONAL INFORMATION:

The transaction log for database 'msdb' is full due to 'ACTIVE_TRANSACTION'. (Microsoft SQL Server, Error: 9002)

    Warning: Database created by the wizard is not cleaned up after failure. 
3
  • Error message is clear. Log file for msdb database is full. Check if the recovery model of msdb is full? If yes you need to take log backup or change to simple recovery. Also check if the autogrowth is turned off or max size of file is limited. Is there free space available where msdb log file reside? – SqlWorldWide Jul 11 '17 at 17:39
  • @SqlWorldWide, msdb in Simple recovery model. File growth was set it up for Auto growth by 10% increment. Yes, lot of free space in msdb logfile (till now it consume 768 kb) – CR241 Jul 11 '17 at 18:08
  • Is the error referring to one of the target server? – SqlWorldWide Jul 11 '17 at 18:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.