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.
| Author |
Topic |
|
sinu009
Starting Member
5 Posts |
 Posted - 2008-03-03 : 05:14:32
|
| have query flash back facility in sqlserver 2005? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-03 : 05:21:45
|
| In SQL Server 2005, you can use something called as Database Snapshot.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sinu009
Starting Member
5 Posts |
Posted - 2008-03-03 : 05:45:06
|
| but sir snapshot is read only copy of databaseI have delete all rows emp table and commit at 1:00 can i flash back to 2:45 ?ifhow? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-03 : 05:48:06
|
| If you want to restore the database upto specific time in past, I guess you are talking about point-in-time recovery.Read this: http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
flash back