Ol'SureHand (1/15/2009)

---

Nevertheless, if databases are small enough to back up in full and we don't have to offer point-in-time data recovery, the log can be truncated every night as it...

I thought as much.

Just note with the solutions above, there's no guarantee of order. It...

Please read through this - Managing Transaction Logs[/url]

I just noticed that you're backing up the log with NO_TRUNCATE. Why?

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Why do you want to concatenate the values?...

Google tells me that Operating System error 21 is "The device is not ready." It's saying that the file can't be accessed at all, not that a couple sectors are...

Take the database into single user mode. That means that no one can access it for the duration of the fix. You may want to shut down sharepoint (if that's...

From redGate's site:

Please note that SQL Log Rescue does not support 64-bit versions of SQL Server or...

Same here.

I am amazed by the patience of some...

How much will you lose by restoring the backup? This is repairable, but you're going to lose what's probably a document. Not easy to say which one.

To offer any real help, I need to see the deadlock graph.

Without that, I can give you generic advice - make sure all your queries are written a optimally as...

SQL does a good job of caching frequently used data in memory, if there's sufficient memory available. If the tables in that database are used often, they will be in...

Why do you need to shrink the log?

Please read through this - Managing Transaction Logs[/url]

Minaz Amin (2/27/2007)

---

1. Backup the transaction log.

2. Shrink it.

3 Create a maintenanace plan to do the...

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

DBCC TRACEON(1222,-1)

Ouch.

Firstly, there's a hardware error. You may want to check and even replace the drives. Personally I wouldn't be ahppy about putting a database back on shaky hardware.

There's a single...

The error events. Exception, errorlog, user error message, attention. There may be some others worth checking.

How long are you planning running profiler for?