Wednesday, March 7, 2012

How is SQL Server Loosing Saved Data?

SQL Server Records that I saved yesterday do not keep the saved data.

When I browse the saved records the next day the saved information is lost.

Is there a way to detect what is causing this?

So many things could be the cause, but the first thing that comes to mind is: are you working within a transaction? If you start the day with a BEGIN TRAN and forget to end with a COMMIT TRAN, Sql Server's going to roll back your work.

Are you backing up your database daily?
Are you working in some development environment that is restored from a prior backup every night?

How are you editing the data that you are creating? and how are you "browsing" your saved records ?

No comments:

Post a Comment