Solved

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

Posted on 2016-11-03
1
45 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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now