Hi all.
Is there possible to create a database savepoint . I mean : i have a database A , and i create a savepoint of this database ( still don't know how to do this ) named K every morning , after that whenever problem occurs i will roll back the database to the savepoint K . I tried to search for a few days for this but no use . Please help me to solve this problem .

hoangnnm:

Hi all.
Is there possible to create a database savepoint . I mean : i have a database A , and i create a savepoint of this database ( still don't know how to do this ) named K every morning , after that whenever problem occurs i will roll back the database to the savepoint K . I tried to search for a few days for this but no use . Please help me to solve this problem .

You could back up your database every morning, and then if something goes wrong you can restore this backup. You can read more about backups on Books Online http://msdn.microsoft.com/en-us/library/ms175477.aspx

Regards,
  Andras

---

András