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