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 |
|
kingsfan01
Starting Member
2 Posts |
 Posted - 2009-04-25 : 16:58:52
|
| Hello - I am hoping someone on these forums may be able to help with a problem I am having on a SQL 2005 DB. I have a DB that I ran a script against which ran a bunch of drop operations and cleared data out of the DB. Due to an issue with our backup software, the DB hasn't been backed up (I know... I know). The DB was setup in simple mode and I can see that the log file is still at 28GB, I'm hoping there is a way to restore the data from the log file (ldf) or ideally rebuild the DB from the ldf. Is this something that is possible? I'm not familiar with T-SQL so any help or tool reccomendations would be greatly appreciated.Thanks in advance,Tyler |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-04-26 : 01:03:13
|
| If the database was in simple recovery mode, the log will will not contain anything.Unless you have a database backup, you have nothing you can recover your data from.CODO ERGO SUM |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-26 : 05:04:50
|
| The 28 GB is just the size of the log file, not necessarily the size of the log itself. Use DBCC SQLPERF(LogSpace) to see how much of that 28GB is used. My guess, almost nothing.--Gail ShawSQL Server MVP |
|
|
|
kingsfan01
Starting Member
2 Posts |
Posted - 2009-04-27 : 09:19:29
|
| Hi Gail & Michael,Thanks for your reply... you are correct, the log files are empty. Looks like I get to go back to failback option 2 (replaying e-mail into the DB)... luckily it is only 2 weeks worth of data.Thanks again,Tyler |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-27 : 11:44:14
|
| And set up a proper backup strategy.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Help restoring data from log file