DB Strategy on MSSQL Server

by amanullah   Last Updated October 10, 2019 07:06 AM

I am asked to prepare a Database Strategy for my Company? My company is using MSSQL Server 2016 with 1 instance and 10 databases. What should I include in the Database Strategy? Any format or template?

Tags : sql-server


Answers 1


In strategy what do you try to ask?

  • RTO: Recovery time objective, how do you have to restore data and how much data are you allowed to loose,
  • SLA: How fast does it need to be and how are maintenance windows managed between the data owners,
  • Features: What version of SQL server do you need,
  • Data sizing: How much data will the system have in N years from now, do you have a storage strategy, RAM needs?,
  • Data retention: how long do you need to retain the data for legal compliance,
  • Users: Data sensitivity and authentication schemes that need to be supported,
PPann
PPann
October 10, 2019 07:00 AM

Related Questions


Updated September 03, 2018 18:06 PM

Updated October 14, 2019 10:06 AM

Updated March 16, 2016 08:02 AM

Updated July 10, 2018 15:06 PM

Updated April 17, 2019 14:06 PM