that made me LOL out loud.

diagnostic manager could be wrong i suppose.

I have checked quite a lot of counters. Initially, just adding the max server memory for the 2 instances plus the...

thanks gail. unfortunately, management *boo hiss* want to know why before solving the problem.

thanks for the reply. unfortunately, i cant see anything in the other classes that would help. I did find this blog post which couldve helped....but cant find the...

Marios Philippopoulos (9/20/2011)

---

uncle_boris (9/20/2011)

---

I have run the code below on the temp db.

SELECT * FROM sys.dm_io_virtual_file_stats(DB_ID(N'tempdb'),null);

The output shows it has had activity on both tempdb datafiles (ID 1 & 3)

Do...

there are multiple biztalk dbs that need to be backed up to a consistent point across all the databases. there is nothing unusual about the backup, just the logic...

I've had issues where tempdb has become full because of a rogue query and so SSMS wont respond and i've used sqlcmd to connect and kill the query. might...

SELECT command FROM msdb.dbo.SYSJOBSTEPS

might be a helpful start point.

as others have said, theres nothing in the oracle world that mirrors SSC which is a great shame as once you get past the basics of oracle, you really need...

yep. as far as i'm aware, the differntial backup only records data changes since the last differential. so if you need to restore to the 29th differential, you...

have you restored the 6 earlier differential backups?

by the way, the prime minister of the UK is gordon brown.

http://en.wikipedia.org/wiki/Gordon_Brown

although the way he's carrying on it'll probably be someone else come june 2010.

running dbcc checkdb is a good way of finding out if your database has any logical and physical errors.

http://msdn.microsoft.com/en-us/library/ms176064.aspx

the sysobjects view is used for backward compatibility for 2000. the sys.objects is the new 2005 view.

http://msdn.microsoft.com/en-us/library/ms345408.aspx