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 |
|
chetanb3
Yak Posting Veteran
52 Posts |
 Posted - 2009-01-29 : 05:50:19
|
| Any one has idea about the point in time recovery.I do not have any bcakup of databae. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-01-29 : 05:53:51
|
| Maybe with a log reader tool, assuming you have the database in full recovery mode. Other than that, there is no way without backups.Sorry to say it, but this is one way to learn how important backups are. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-29 : 06:29:15
|
| If there's no backup ever, a log reader won't help, as the log will be auto-truncating regardless of recovery model. Log records are only kept after the first full backup is done.No backup = no data.--Gail ShawSQL Server MVP |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-29 : 06:35:01
|
And that's how cookies crumble 
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
I deleted one table ,how can I restore it.