(SS2008 Developer Training Kit) db restore fails due to journal overfilled

Unanswered (SS2008 Developer Training Kit) db restore fails due to journal overfilled

  • Wednesday, July 15, 2009 1:35 PM
     
     

    Hello,
    I follow
    "Adventure Works Racing Community" demo from
    SQL Server 2008 Developer Training Kit
    Step-by-Step Walkthrough
    file:///C:/SQL2008TrainingKit/Demos/AdventureWorksRacingCommunity/Demo.html/html/DocSet_e56c787b-c1ca-407d-828d-5865fe27042e.html#_Toc227564958

    It tells there:

    • “5. Open %TrainingKitInstallationFolder%\Presentations\AdventureWorksRacingCommunity\AdventureWorksRacingCommunity.pptx
    • 6. (Segment 3) Restore the Data Mining Structure in the SQL Server Analysis Service Instance. To do this:
    • a. Connect to Analysis Services in Management Studio
    • b. Right click on Databases and click Restore.
    • c. The Backup file is located at %TrainingKitInstallationFolder%\Demos\AdventureWorksRacingCommunity\BI\AdventureWorksRacingDM.abf.
    • d. Name the database AdventureWorksRacingDM, and click OK.”

    ?? What is the import of opening PowerPoint 2007 presentation for this step (Should I buy and install MS Office 2007 in order to follow this instructions?)

    I cannot complete the step 6, receiving messagebox [1],
    telling me that, if I correctly understand Russian, "Journal of Events is overfilled."

    Which of the journals, where?

    I tried various steps (e.g. changing directories to the proposed  by MSSQLSer 2008 directories)
     but the result is the same.
    What should I do in order to proceed?

    I am on MS Windows XP SP3, MSSQLServer 2005 SP2 (default instance) and MSSQLServer 2008 Developer Eds. (named instance SQL2008)

    [1]
    Error message(box) text:
    "

    Ошибка файловой системы: При записи в файл "MSOLAP$SQL2008" произошла следующая ошибка: Журнал событий переполнен. .
    Ошибка файловой системы: При открытии файла "C:\SQL2008TrainingKit\Demos\AdventureWorksRacingCommunity\BI\AF90854451644224BB4\AdventureWorksRacingDM.1.db\vTargetCommunityAds Structure.0.dms\vTargetCommunityAds - Naive Bayes - All Demographics.0.dmm\1.vTargetCommunityAds - Naive Bayes - All Demographics.cnt.bin" произошла следующая ошибка: .
    Сервер: Операция отменена.
    (Microsoft.AnalysisServices)

    ------------------------------
    Program Location:

    at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
    at Microsoft.AnalysisServices.AnalysisServicesClient.Restore(String file, String databaseName, Boolean allowOverwrite, ICollection locations, RestoreSecurity security, String password, String dbStorageLocation)
    at Microsoft.AnalysisServices.Server.Restore(String file, String databaseName, Boolean allowOverwrite, RestoreLocation[] locations, RestoreSecurity security, String password, String dbStorageLocation)
    at Microsoft.AnalysisServices.ManagementDialogs.RestoreDialog.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)
    at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
    at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForOlap(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
    at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
    at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)"


    Guennadi Vanine -- Gennady Vanin -- Геннадий Ванин