(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 -- Геннадий Ванин- Edited by Gennady Vanin - Геннадий Ванин Новосибирск Wednesday, July 15, 2009 3:11 PM

