I'm no expert, don't really know much about split-mirroring.  Does it require more hardware ?   A cheap way to improve might be to get SQLSafe (or a competitor). Then your...

One instance would be my vote, unless you have a compelling reason for multiple instances. The only case where we have multiple instances on 1 server is to allow a...

What's a LVL0 backup ??

4-5 hours to backup a 100 G database ?!?!  

My 280 G database backup with backupexec takes about 1 hour to tape, and if I use...

You can use  DBCC INPUTBUFFER (59) to get a bit more information about what a spid is doing.

I don't remember exactly.  But I think it was a combination of table schema changes, and triggers put on tables based on the old schema, not the new schema that...

Yeah yeah ... I know .... smartass !!

Got it !!      Detach & re-attach.   Some DBs were moved to new storage recently ...   Too bad that it wipes out the real creation date 🙁

Thanks for helping

No. These databases have creation dates within the last week or so, and I haven't done anything with them in months.

I found I was able to get Idera's Diagnostic Manager to connect to the remote server - I had been only using it locally. It  gives me much more information,...

Maybe Noel's method would be better, as long as replication will be unaffected.  

Is your database a publisher or a subscriber ??    Mine's a subscriber, so I will just dis-able...

I'm doing the same thing this weekend. I'm planning on stopping replication, unmarking the DB as used for replication by setting  CATEGORY = 0 is sysdatabases, detaching the DB, moving...

Thanks.   I just started running a trace, and although I selected database name to display, that column is blank, although there is what looks like a good value in Database...

Yes, Dumb, but I've probably tripped over that before !!  🙂     In this case, I'm pretty sure I've got the right file.

EDIT: My bad. I was mixing up different instances...

I don't know if any tape backups were running, but I doubt it's factor since other DBs on the same drive were fine. Good question though.

There were no active connection...

"... The use of TRUNCATE would be better on the deletes but I believe that truncate won't work in the presence of foreign keys ..."          Sad but true.

I'm already in...