Solved

Microsoft SQL Server 2016 -- RECOMMENDED "backup" SOLUTION, INJECTION attack notification ?

Posted on 2016-11-03
1
73 Views
Last Modified: 2016-11-08
I already have RAID, etc like https://msdn.microsoft.com/en-us/library/cc296756(v=bts.10).aspx talks about and am thinking about FAILOVER CLUSTERING like https://support.microsoft.com/en-us/kb/822400 talks about and LOG_SHIPPING like http://sqlmag.com/database-backup-and-recovery/poor-mans-disaster-recovery-use-log-shipping-sql-server-your-own-risk talks about

 1. What Microsoft SQL Server 2016 onPremise "backup" SOLUTION do you RECOMMENDED if you have UNLIMITED budget to prevent downtime ?

 2. What SOLUTION do you RECOMMENDED to notify you when potential INJECTION attacks happen ?
0
Comment
Question by:finance_teacher
1 Comment
 
LVL 5

Accepted Solution

by:
Austin Texas earned 500 total points
ID: 41873320
1. Backup is part of your disaster recovery plan which is separate from your redundancy solutions which fall into your high availability plan. Two different things.

2. I'm sure there are others, but the only IDS I am aware of with NIDS specific to SQLi is the AlienVault product.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question