The database I am currently building is in a rather specific setup and the general advice I can find for backups is very vague when considering my situation, here's a run down:
We're running SQL Server 2012 Express as a service on a computer connected to our network with no network connectivity outside monitoring the network port. I.e. our main network is inivisible to SQL Server.
Currently we have a daily full backup running via a Windows scheduled task that launches a stored procedure.
One of the problems we have here is the speed of data that will be processed on this db, one table is going to have about 1K - 1.5K records added per day and another with be about 4K - 5K records per day. The table that sotres 1K - 1.5K records per
day can potentially be recovered by other means as this is just records from another system, but the other table cannot be restored like that as it builds all the data by tracking what users a ...
Go to the complete details ...