LPS:Windows Servery/odin

Z HelpDesk

Manazersky Informacni System (magion) (RT#125848)


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. 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)
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>
Citováno z „https://helpdesk.zcu.cz/index.php?title=LPS:Windows_Servery/odin&oldid=62262“