carlosm
Reputation: 755
Recover updated data on a table
I need to recover an update on a column that I did yesterday on SQL Server 2014, is there a way to get the old data? Can I get it without doing a full restore ?
Upvotes: 0
Views: 92
Answers (1)
David Browne - Microsoft
Reputation: 89361
Can I get it withput doing a full restore ?
No. Restore from a backup to a new database and copy the data you want.
Upvotes: 1
Related Questions
- How to keep track of changes to data in a table?
- Return table of changed rows
- How to get the prior data which is changed using SQL Server
- How to recover deleted rows from SQL server table?
- How to retrieve the history of changes happened to a particular Id in a table in SQL Server
- Retrieve data from changed rows records
- Updated a table based on a condtion Sql server?
- How to recover a deleted row from SQL Server 2005 table?
- How to recover the old data from table
- How to create a query that gets only data which has been updated in a table