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 |
|
Obadiah
Starting Member
2 Posts |
 Posted - 2012-03-05 : 09:41:14
|
| I have never done this before. Can anyone assist me with this? what is the best tool to use? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-03-05 : 09:52:22
|
| There are many ways to screw a database......We can't answer the question until we know what you have.Do you have a sql serve backup? a .bak file?is this from a database in simple recovery model / full recovery / bulk logged.Do you just have the .mdf and .ldf files?What's your situation?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
Obadiah
Starting Member
2 Posts |
Posted - 2012-03-05 : 10:04:32
|
| well...my admin tells me that he overwrote the database with last night's backup. the situation was that i was working in ektron mistakenly deleted a taxonomy. There was no way to recover it so I just wanted to see how it was structured to I could relink the information. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-03-05 : 10:09:48
|
| So are you trying to get back the data that was lost since the restore?I don't think there is any way unless you have a backup of the db taken just before the restore?if you do then tell us the files you have and we can help.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-05 : 10:11:07
|
| Do you have a full backup from before the accidental deletion?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Mounting a database