Zobrazení zdroje stránky LPS:Windows Servery/odin

=odin=
* odin.zcu.cz -> 147.228.52.122
* server je v domene w3k.zcu.cz
* systemovy disk 80G zrcadleny ''phy:/dev/vgxen/odin.disk''

* Windows 2008 SP2 32b CZ
* MSSQL 2008 Standard
** data v D:\MSSQL 
** Analysis Services v D:\MSSQL\OLAP

* administratorsky pristup externi dodavatel Magion (login: grigar, magion)
** Petr Zlebek email: petr.zlebek@magion.cz
** Zbynek Stedry email: zbynek.stedry@magion.cz


* Pridani pristupu pro uzivatele
** Spustit SQL Server Management Studio a prihlasit se k '''Analysis Server''' 
** Databases > mis > Roles > ''prislusna role'' > Properties > Membership > Add (viz. [[:Soubor:MIS PridaniUzivatele.PNG| Screenshot]])
** Umistneni w3k.zcu.cz a pridat login uzivatele (je treba znat domenovy ucet! staci ucet '''register''')

* Reporty
** Ecelovske reporty lze stahnout z ''D:\magion\Reporty''
** Je treba mit pridelene pravo v DB a spoustet na Orion stroji v domene (overeni k DB je integrovane overeni systemu windows SSPI)





{| class="tabulka"
|+ <font size="4">'''Parametry'''</font>
|- 
! RackMonkey
| [https://rackmonkey.civ.zcu.cz/rackmonkey/rackmonkey.pl?view=device&view_type=single&id=344 odin.zcu.cz]
|-
! Type 
| XEN
|- 
! CPU 
| 2x 
|-
! RAM
| 4G	
|}





===zalohovani===
* Bacula
 File = "c:/"
 File = "d:/backup"
 File = "d:/magion"
 File = "D:/MSSQL/BACKUP"
 File = "d:/WindowsImageBackup"
** exclude: Pagefile.sys, System Volume Information, RECYCLER
** 1.patek v mesici '''Full'''
** tydne '''Increment'''

===naplanovane ulohy===
* bezi pod systemem s nejvyssim opravnenim
* 01:00 (1. Ne v mesici) '''C:\Program Files\_skript\SystemBackup.cmd'''
* 03:50 (v nedeli) '''SafeBackup MIS''' (presune databazove zalohy MSSQL Analysis Services a smaze stare)
* 18:00 (24. v mesici) '''Aktualizace MIS''' (D:\magion\RunEtl\RunETL.bat)


* MSSQL
** 1:00 (1.sobotu v mesici) '''Udrzba''' (check integrity, Reorganize Index, shrink database, History Cleanup)
 V Udrzbe je pridan dalsi Step '''Zaloha a orezani TranLogu''
 -- Backup Transaction log file
 BACKUP LOG [mis] TO  DISK = N'D:\MSSQL\BACKUP\LOG\MISLog.trn' WITH NOFORMAT, NOINIT,  NAME = N'mislog', SKIP, REWIND, NOUNLOAD, COMPRESSION,  STATS = 10
 GO
 -- Shrink the truncated log file
 USE mis
 GO
 DBCC SHRINKFILE (mis_log, 1)
 GO

** 0:15 (v sobotu) '''BackupMaster''' (Check integrity, Maintenance Cleanup [2mesice], Back UP Database[systemove])
** 4:00 (v nedeli) '''BackupMIS''' (Back UP Database[MIS, ReportServer], Maintenance Cleanup [2mesice])
 V BackupMIS je pridan dalsi job '''OLAP Backup''' Zalohuje se do preddefinovaneho umistneni ''D:\MSSQL\Backup\OLAP''
 <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <DatabaseID>mis</DatabaseID>
  </Object>
  <File>mis.abf</File>
  <AllowOverwrite>true</AllowOverwrite>
 </Backup>