Just a thought. Does your application has some sort of db maintainence code written in it which truncates log if it is getting full?

btw, i ran profiler and captured...

tried to simulate your situation.

create database testdd on primary(name='testdd', filename='c:\testdd.mdf')

log on (name ='testddlog', filename='c:\testddlog.ldf')

-- setting database to offline mode

alter database testdd set offline

-- now deleting mdf file

xp_cmdshell 'del "c:\testdd.mdf"'

-- trying...

Patricia Johnson (11/22/2010)

---

I am using SQL 2000. Sorry about that. We are planning to upgrade to 2008 but until then I'm here.

I have looked at all...

You can take a backup of the database, copy the backup to target server and restore over there.

You can increase SQL Server memory usage to upto 3 GB by using /3gb switch.

You mentioned slow...

Thanks Gail. I cross verified this one.

Gail, just checked and its showing NTUsername for my user. i am connected using a local userid/pwd.

Login name it's showing as machinename\username

What is scheduler?

Do you mean the scheduler which is mapped to logical CPU? or something else?

What do you want to trace? What do you mean...

can u clarify more.

DataDog (11/18/2010)

---

connection 1 - get lock on index A

connection 2 - get lock on index B

connection 1 - waits for lock in index B

connection 2 - deadlocks on lock for...

yes. It would be better if you zip the backup and then copy. this would reduce copy time.

ravisamigo (11/18/2010)

---

What might be the issue if I can see more locks when I ran a below query.

SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id

ORDER BY count...

Thanks Gail. Need...

You need to find out which particular log backup file didn't get restored. If you cannot dig into what caused the failure, simply take a backup of production and restore...