January 23, 2020 at 1:47 am
Hi. I would like to know is it possible to recover data log table from SQL Server 2014 without backup file?
January 23, 2020 at 8:18 am
Any form of recovery will need a backup.
The caveat would be if your in FULL recovery and have not backed up the transaction log after the point in time you want to recover, you could then read the active portions of the log and find out what happened.
But 99.999999% of the time, you need backups
January 23, 2020 at 1:50 pm
Piling on because this bears repeating.
Yes, in order to do recovery you need backups. Further, in order to ensure your backups are good, you need to test them regularly. The single best test is a restore of that backup. You should have backups and backup testing set up on your systems and completely automated. If you don't have it, that's your very first task at work today.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply