Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 restore database to an early state

Author  Topic 

juanjo
Starting Member

2 Posts

Posted - 2007-05-16 : 11:10:00
Hello,

I am using a SQL Database.

I want to know if there is a way to restore a database to an early state.

i made some changes on the entries and now the relations between tables are all messed up.

Need your help.

Thanks in advance.

nr
SQLTeam MVY

12543 Posts

Posted - 2007-05-16 : 11:19:08
You can restore an earlier backup.
If you have transction log backups then you can then restore to a point in time (if you're lucky).

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -