You would need to copy the ldf file as well to do the job properly.

Leo

I wonder if your original DROP Table command is still rolling back. Could be.

How big is the log file?

Leo

There are 10 types of people in the world.

Those who understand binary...

In a new query window run SP_WHO2 to see if the truncate is blocked by another spid.

Leo

There are 10 types of people in the world.

Those who understand binary and and...

Indianrock (5/24/2010)

---

CV? I raised objections when backups etc were moved to Systems -- don't feel any need ( or use ) in going further with that. As I...

I'd hardly call stopping a production server a "spur of the moment" thing, but it would work. But how do the users feel about the database going off line for...

Round about now I would start dusting off my CV.

Good practice has always been to do SQL Native backups to DISK, then copy to tape. I know some 3rd party...

You may also want to consider adding some database optimisation jobs. Consider rebuilding indexes over the weekend.

Leo

There are 10 types of people in the world.

Those who understand binary and and...

Is this a new build? Has the failover worked before or did this suddenly start happening?

Can you give a little bit of history here.

Leo

There are 10 types of people in...

Working as a consultant I see it all, and many of the companies that call for my service do so because they didn't have the money or feel the need...

sanketahir1985 (5/23/2010)

---

exactly Leo, i do agree with that

i already told them to use temp table approach to resolve deadlock problem

but developers are not convinced with that,so i was looking for...

This is interesting. I know you can (and I have had to) Slipstream the SQL 2008 RTM and SP1 media so the installs are done as one, but I've never...

sanketahir1985 (5/21/2010)

---

but let me tell u my scenario

actually SP_ClientBPS runs after every 5 sec. thru console program

while Sp_IEActiveScreen gets fired randomly by users avg freq is 5-10 hits per...

If these are SQL 2000 Jobs you are talking about I would set each step to "on failure go to" and send it to a special "Send e-mail on failure"...

You can just genereate the commands for each database by running this in master. Then run the output in master. Just replace UserName with the name in the database. If...

Correct, dropping a login doesn't remove the user from the database. You need to go through each database and find all the orphaned users and drop them at the database...