(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
nice post.tableau online course
ReplyDelete