LPS:Windows Servery/odin

Manazersky Informacni System (magion) (RT#125848)

odin

• odin.zcu.cz -> 147.228.52.122
• server je v domene w3k.zcu.cz
• MSSQL 2008 Standard

• systemovy disk 80G zrcadleny phy:/dev/vgxen/odin.disk

• Windows 2008 SP2 32b CZ

• administratorsky pristup lokalni sprave RICE (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. 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)

Parametry

RackMonkey	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)
  • 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])