It used to be that when you deleted a database file, the physical files were not removed. so you could attach them again. That doesn't happen any more.

The mirror database should be in the restoring status. It is in that state so that new logs can be applied to the database.

If the principal goes down, then you may or may not be able to get a mail.

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

http://www.petri.co.il/mount_iso_files_in_windows_vista.htm

http://lifehacker.com/180124/mount-an-iso-file-without-burning-a-disk

didn't notice the comma, but I realized the intent of the question.

People hire people. Interviews are where a candidate makes an impression. But when narrowing down who to bring to an interview, or in who a recruiter can help sell to...

That profiler statement shows a creation of a temp table and then an insert of logspace information. Nothing should be happening in the model database. If you set the model...

I agree with Luke. If you start a tran, the optimizer doesn't lock everything referenced.

Begin tran

waitfor('1:00:00')

update sales

set price = price * 1.5

commit tran

The sales table will not be...

Run Profiler, set to filter to the model database and look for activity. Something is occurring in there.

Interesting. I think that the GUI makes it fairly easy for someone to click too quickly, or the wrong place, and make a mistake. I've seen people, myself included, who...

First start basic SQL Server monitoring. The virtual instance is what you should monitor. Here's one ref: http://www.mssqltips.com/tip.asp?tip=1663&home

then I'd read up on clustering to understand how it works. There are...

First, if someone gets administrative permissions on the machine, it doesn't matter what you do. The data will be compromised. Windows authentication is always enabled, so someone will get to...

sorry, haven't done enough production work with 2008. The Truncate_only option isn't in 2008.

As noted here (http://msdn.microsoft.com/en-us/library/ms144262.aspx), when you switch to simple mode, the log is truncated, so I'd follow...

Here's a ref from the SQL team

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

Need to teach those techs how to run with scripts (DMVs, sys., etc) rather than SSMS!