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


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 data mining structure in sql server analysis service instance. this:
  • a. connect analysis services in management studio
  • b. right click on databases , click restore.
  • c. backup file located @ %trainingkitinstallationfolder%\demos\adventureworksracingcommunity\bi\adventureworksracingdm.abf.
  • d. name database adventureworksracingdm, , click ok.”

?? import of opening powerpoint 2007 presentation step (should buy , install ms office 2007 in order follow instructions?)

i cannot complete step 6, receiving messagebox [1],
telling me that, if correctly understand russian, "journal of events overfilled."

which of journals, where?

i tried various steps (e.g. changing directories proposed  mssqlser 2008 directories)
 but result same.
what should in order proceed?

i on ms windows xp sp3, mssqlserver 2005 sp2 (default instance) , 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 - demographics.0.dmm\1.vtargetcommunityads - naive bayes - demographics.cnt.bin" произошла следующая ошибка: .
Сервер: Операция отменена.
(microsoft.analysisservices)

------------------------------
program location:

@ microsoft.analysisservices.analysisservicesclient.sendexecuteandreadresponse(impactdetailcollection impacts, boolean expectemptyresults, boolean throwiferror)
@ microsoft.analysisservices.analysisservicesclient.restore(string file, string databasename, boolean allowoverwrite, icollection locations, restoresecurity security, string password, string dbstoragelocation)
@ microsoft.analysisservices.server.restore(string file, string databasename, boolean allowoverwrite, restorelocation[] locations, restoresecurity security, string password, string dbstoragelocation)
@ microsoft.analysisservices.managementdialogs.restoredialog.dopreprocessexecution(runtype runtype, executionmode& executionresult)
@ microsoft.sqlserver.management.sqlmgmt.sqlmgmttreeviewcontrol.dopreprocessexecutionandrunviews(runtype runtype)
@ microsoft.sqlserver.management.sqlmgmt.sqlmgmttreeviewcontrol.executeforolap(preprocessexecutioninfo executioninfo, executionmode& executionresult)
@ microsoft.sqlserver.management.sqlmgmt.sqlmgmttreeviewcontrol.microsoft.sqlserver.management.sqlmgmt.iexecutionawaresqlcontrolcollection.preprocessexecution(preprocessexecutioninfo executioninfo, executionmode& executionresult)
@ microsoft.sqlserver.management.sqlmgmt.viewswitchercontrolsmanager.runnow(runtype runtype, object sender)"


guennadi vanine -- gennady vanin -- Геннадий Ванин



SQL Server  >  SQL Server Samples and Community Projects



Comments

Post a Comment

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........