2

I have accidentally updated over 3,000 records in one of my tables hosted on Azure. This was not a transaction and I did not have any back ups for this table.

I've read around and found ApexSQL Log but when I connect I try to connect I see "SQL server Azure is not supported"

I understand that this tool examines logs to reproduce the data, is there a manual technique to do is, or an alternative compatible tool?

I also found this tutorial but after running it on Azure I see 'Invalid object name 'fn_dblog'

Really grateful for you support.

Thanks.

8
  • any backups of your data ? restore from there
    – M.Ali
    Sep 6, 2014 at 21:36
  • don't suppose you have a backup you could restore elsewhere and evaluate the changes that way?
    – Kritner
    Sep 6, 2014 at 21:36
  • Have a look here maybe this will help Recover deleted data in SQL Server
    – M.Ali
    Sep 6, 2014 at 21:43
  • No unfortunately I did not have a backup of the table...
    – User24231
    Sep 6, 2014 at 22:05
  • 1
    Sadly not. Web or Business edition only support manual database copy or export at this time and are due to be retired in 2015. Did you take any kind of manual backup? If so, you could re-deploy it as a different db name, extract the data eg with bcp, SSIS, and reload the table, basically effecting a table-level restore. How did the data get there in the first place?
    – wBob
    Sep 7, 2014 at 12:55

3 Answers 3

4

I have accidentally updated over 3,000 records in one of my tables hosted on Azure.

You are out of luck (since you do not have any backups).

Also, it is not possible to use the undocumented command fn_dblog in Azure. It is only supported in SQL Server.

Also Transaction logs are no longer managed by the DBA in SQL Azure; this is automatically managed by SQL Azure's infrastructure.

check out : Supported Transact-SQL Statements (Azure SQL Database)

0

Which edition of SQL Azure are you using?

If its one of the newer editions, you can make use of the Point In Time recovery

http://msdn.microsoft.com/en-us/library/azure/jj650016.aspx

2
  • 1
    Web edition (as the OP has) does not support point in time recovery.
    – Kin Shah
    Sep 7, 2014 at 15:09
  • @kin ah.. that info was added later. I'll still let this be here if anyone using the new editions stumbles on this question...
    – Akash
    Sep 7, 2014 at 18:17
0

ApexSQL Log doesn't support SQL Azure because the transaction log file is differently handled in SQL Azure, and cannot be physically read by a tool.

I work in ApexSQL

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.