| Author |
Topic |
|
bipank
Starting Member
2 Posts |
 Posted - 2008-01-08 : 02:14:48
|
| Hi All,I have sql server 2000 enterprise edition on win 2k3.I have important database and its in full recovery mode and i have not taken any single full backup of the same database.Problem is data from one table is deleted suddenly and i know the time when it was containing all missing data.So is it possible to get into that data with only n only single transaction log backup???????Bipan |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-01-08 : 10:05:34
|
| Unfortunately, no. A transaction log backup needs a full backup as a reference point from which to re-apply transactions to. You can think of a transaction log backup as a set of directions like "take three steps West. Turn 80 degrees right, take 5 steps forward...etc.". Without knowing where to start, you will have almost no hope of getting to where you want to be. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-08 : 10:51:02
|
| you might try using 3rd party transaction log reading tools._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:54:21
|
| Not backup important database? Don't get it. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-09 : 16:39:34
|
| the answer to the original question is yes. you can use tools like lumigent log explorer, apexsql log and quest litespeed ent edition now has log reader functions (untested by me though, so ymmv).give those tools a test. The lumigent tool eval only works on the SQL Server sample databases though. Apexsql will work against any database (or atleast it did when I evaled it).-ec |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-09 : 16:43:21
|
| oh, also perform a full backup before doing anything. you need to implement regular incrementals also. this is the first thing you should have done btw. Not having backups is something you get fired over.-ec |
|
|
|
rupam
Starting Member
1 Post |
Posted - 2008-01-27 : 23:38:39
|
| I know sql server to an extent. To develop self how shold i do practice.And what should i learn.rupa.m |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-27 : 23:54:18
|
| What do you like to learn specifically? |
|
|
|
|
recovering databases with only transactionlog