MS SQL Server Maintenance & Backup Strategy
Because we give – for you – more.
In Iphos IT Solutions you have found a state-of-the-art full-service IT service provider
who implements your projects faster, more cost-efficiently and more sustainably.
The Company
In 2000, the Upper Austrian Transport Association Organization Company became a limited liability company owned solely by the state of Upper Austria. furnished. Its goal is to provide the population of Upper Austria with a needs-based, qualitatively and quantitatively optimal range of local and regional public transport.
The task
There was an urgent need for a general overhaul and regular maintenance for the Microsoft SQL Server of the Upper Austrian transport association. The focus of the project was on the following:
- MSSQL performance checks
- Analysis of the database server
- Analysis of the recovery model
- Analysis of the maintenance plan
- Optimization of databases
- Optimization of the backup strategy
- Optimization of system resources
- migration planning
- Ongoing patching & maintenance of the MS SQL Server
The solution
Our Microsoft-certified IT specialists ensure smooth operation of the database server of the Upper Austrian transport association as part of an MSSQL server maintenance contract:
- Comprehensive performance analyzes (database server, MSSQL agent jobs, TLOG VLF fragmentation, indexing, ...)
- Analysis and optimization of the recovery model
- Optimization of the MS SQL databases
- RAM optimization
- Migration planning and execution
- MSSQL server setup
- Install SSRS and SSAS
- Conception of backup strategy
- Set up system maintenance schedules
- licensing
- Ongoing maintenance (remote and on-site)
Technology & highlights
- Center
- Microsoft SQL Server Analysis Services (SSAS)
- Microsoft SQL Server Reporting Services (SSRS)
- Microsoft SQL Server
- Monitoring solution (Nagios)
- VEEAM Backup
The results
The MSSQL servers of the Upper Austrian Transport Association are in good hands with the IT technicians at Iphos IT Solutions. After a thorough analysis of the system, the server and processes as well as the backup and recovery strategy were optimized. Licensing planning that is geared to the actual needs of the customer now saves costs.
Maintenance plans and regular maintenance tasks ensure that the transport association's Microsoft SQL servers run smoothly.
Company
A strong international company - for the best IT solutions. Iphos IT Solutions offers its customers a full service in the areas of EDV / IT / ITSM, software development & web. – Faster, more cost-efficient & more competent.
IT infrastructure
As a holistic & sustainable service provider, we offer top IT solutions for maintenance, consulting, networks, Exchange, Linux & Windows servers and much more
Software Development
State-of-the-art software development from Vienna: as a sustainable & holistic IT company, we work on your best individual solution in the areas of application development, mobile software development, interface development & database development.
Web development
Web development rethought: We develop intranets & extranets, websites, e-commerce, online tariff calculators, newsletter systems & offer classic services such as SEO, SEM, etc. So that your business runs better.
Iphos IT Solutions GmbH
office@iphos.com
Khekgasse 35, 1230 Vienna, Austria
