Good suggestion Kathi,

I'd also have a look at moving the log file to a seperate disk if it's currently on the same one as the data file (assuming that...

Hi trish,

We've has a similar problem in the past too, the problem being that xp_sendmail is an extended stored procedure and we discovered that once one of these processes goes...

Hi Yuri,

Actually we're using the 64-bit enterprise edition on the production cluster but only the standard version on the DR box, hence the requirement to write a custom set of...

Likewise from me, if you need any help or scripts then feel free to contact me.

We're currently log shipping a half terrabyte database from 64-bit to 32-bit systems in different countries...

You'll need to initially restore the database on the secondary server using either the norecovery or readonly option, both of which will allow you to restore further transaction logs (norecovery...

I don't have that much experience with MS Query, but i have used VBA for this sort of thing in the past.

If you don't hear from anyone else then I'd...

Seeing as no-one else has posted here is my offering on why you shouldn't install SQL on a DC.

1. SQL is very memory hungry, installing it on a DC will cause...

I'd say that you're pretty close to what happens with that, a backup log command will only go as far as the last committed transaction and then clear out everything...

I agree, i would definately leave the databases on the SAN and move the backup files to the NAS.

Unless it's a really old SAN then the performance decrease you'd get...

I guess that it might not apply in this case but you should be aware that if you're using full text searching on any tables in a database and detatch...

Good luck, if you need any more scripts or help then feel free to shout.

Sometimes maintenance plans are the way to go, sometimes it's better to do them the old...

not that I would recommend it on a production system but you could put the database into the simple recovery model which would then prevent the transaction log from being...

I had a similar problem, from the looks of it they had to restore an older backup of the system.

I didn't see this explanation anywhere but when it came back...

I agree completely, I've been a SQL DBA for the last 8 years and started at the bottom.  There are many routes into the profession but the best one is...

It could be that the TSQL to drop the index is being blocked by something else running against the table.