It should wok if you have all the tran logs and db is not in simple mode.

I don't have time to do it now but here's the gist of it.

SELECT MIN(t2.time), t1.time, T1.Col1, T1.Col2 FROM Base T1 INNER JOIN Base T2 ON T1.Col1 = T2.Col1 AND...

SELECT

T.name,

STUFF((

SELECT

...

I think I'm using more of a proactive approach that reactive.

As I said earlier I don't understand isolation levels and locking enough to make recommendations so I won't say anything...

SELECT

*,

CASE DocumentStatus

WHEN 4 THEN 'Open'

WHEN 10 THEN 'Closed'

...

Steve Jones - SSC Editor (5/3/2011)

---

The time to restore on a USB drive will vary (SB2, USB3 interface). eSata will be quicker, but it's time.

For Virtual Restore it's very quick....

SQLRNNR (5/3/2011)

---

Ninja's_RGR'us (5/3/2011)

---

And now the moment is gone... 1 too many post and...

Then you might want to look into replication. Maybe it's 1 way to solve the problem (assuming maybe a BI environement and NOT full OLTP.)

Assuming you do a fetch into it'll loop in the next record.

Are you sure the catch is not preventing the next fetch operation?

Or you could have more than 1 copy...

And now the moment is gone... 1 too many post and the sequence...

Syed Jahanzaib Bin hassan (5/3/2011)

---

you can use this command on SQL Server 2008 and 2008 R2 also,if you want to truncate the file just add new log file and restrict...

Steve Jones - SSC Editor (5/3/2011)

---

One thing to think about is keeping a 1TB USB drive around for times like this. Make the restore happen on that volume, then try...

Then you'll like this one, taken a few minutes ago!

toddasd (5/3/2011)

---

HAHA! Acronym confusion levels maxed! By SSMS, I meant SQL Server Migration Assistant for Access that calvo had...

As for the solution you can get a drive with 520+ GB free space.

Or you could restore that db on another server, put in simple, checkpoint, shrink the log to...