I had one of those earlier in the week.

OP: Why is my database still Restoring... almost a day later?

Me: Because you ran the restore WITH NORECOVERY

OP: Oh.

I mentioned it on...

Nor appropriate data types, I would assume.

Get a copy of the database on a server that you do have access to and run upgrade advisor. Fix everything it complains about. Upgrade your test server to SQL...

mstjean (1/15/2010)

---

The OP said they run the process daily, and delete all rows > 7 days old as the final step, so he's never got more than 8 days of...

There should be something in the SQL error log on why the backup failed. Check and see.

andy 21711 (1/15/2010)

---

Thanks for your replies. I realise there are autocommit transactions, but since they are each one statement long, how can there be deadlocks unless one statement manages...

That will check every page in the database for corruption, check the schema, check the allocation information. If there's any form of corruption in the database it'll pick it up...

SELECT name as TableName, ObjectProperty(object_id, 'TableHasPrimaryKey') AS HasPrimaryKey

FROM sys.tables

You cannot create an index that has a varchar(max) as a key column.

CREATE TABLE Test (

id INT,

StringCol VARCHAR(MAX)

)

CREATE INDEX idx_wontwork ON Test (StringCol)

Msg 1919, Level 16, State 1, Line...

Logged as in written to the transaction log?

If so, yes. All operations are logged and there's no way to turn logging off.

If your database is in Bulk-logged recovery, the bcp...

tosscrosby-60625 (1/15/2010)

---

Gail, you know the answer, give the users the ability to kill the offending SPID! Clean and simple solution to keep things quiet while the OP searches madly for...

Run this on all databases that were on the SAN

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

SQL doesn't decide on...

We can't help you with your fight with an interviewer. If you have problems with the questions, take it up with the interviewer if you can.

Transactional replication is configured exactly...

I'm going to stick this in the queue to be looked at over the weekend, cause deadlocks take time to work out.

As for the resources involved in the deadlock:

SPID 62:...