Embarcadero also do something called Performance Centre, I have started to look into this but haven't got far yet. Spotlight seems ok, the downloaded eval version only gives a flavour as...

I have successfully restored mdf files which were backed up from a running server, however, they database wasn't in use so the files weren't being accessed. I hasten to add...

The status 2 records at the time I ran totalled to 16Mb. There were about 9000 virtual Log files. At this time usage was around the 500Mb figure.

Cheers

Rick.

>>Related Question:

>>How can you backup transaction logs onto tape and delete logs weekly so >>your hard drive does not get full ?

Maintenance plans can delete backups which are over...

I'm refering to the output of DBCC SQLPERF(LOGSPACE). I'm not concerned with the physical size, just the amount used. As an aside, I will be shrinking shortly in order to...

No replication that I'm aware of. (I'm new to the environment and still finding my feet). My understanding of 'DBCC OPENTRAN' is that it would indicate if there was a...

A tad unfair I feel. As DBAs we are expected to foresee consequences of actions and just dropping a clustered index to create it on another, more volatile field, would...