You could always have the notification as a job step (one for success, one for failure). Then use sp_send_dbmail.

You'd fail back to the original principal the same way you failed over in the first place.

If your original principal was completely hosed and needed an OS rebuild, you would...

Yeah, run your delete using T-SQL, beginning with a [font="Courier New"]DISABLE TRIGGER[/font] statement and ending with an [font="Courier New"]ENABLE TRIGGER[/font] statement. The trigger will be disabled for ALL connections...

Yes. If SQL Server is started in single user mode, any account with local administrator rights can connect/login to SQL Server and they will have sysadmin rights.

Any errors in your SQL Server ERRORLOG? Here's a list of possible login failure states and their causes:

Error State Error Description

1 ...

You can use the [font="Courier New"]DBCC SQLPERF(LOGSPACE)[/font] command to get a list of sizes + percent used for every database log on your system.

Log truncation does not shrink the physical...

Use SQL Server Configuration Manager. It should take care of any permissions the designated account requires. All you should have to do is type in the name &...

You need to use EXEC or sp_executesql to be able to concatenate USE with @DatabaseName. However, that change in database context will only apply within the EXEC/sp_executesql statement, so...

Copying database files while they are in use is dodgy at best. I can't say I know of any time it has worked. You would be better off...

If it is definitely SQL Server causing the issue, you can track the issue to a specific SPID and from there see what code/connection is causing the issue.

Fire up Perfmon,...

In your cursor declaration, change the select statement to:

[font="Courier New"]SELECT name

FROM master..sysdatabases

WHERE DATABASEPROPERTYEX(name, 'Status') = 'ONLINE'

[/font]

Sounds like somebody has setup a maintenance plan and selected 'all databases' instead of selecting just those databases that need to have log backups done. So...

They'll get applied. When restoring a database, you generally start with the latest full + differential then move onto the transaction logs. However, it is entirely possible to...

The tools used shouldn't make the job harder to do. I agree with the concept of making the tools facilitate the job at hand but not dumb it down.

I...

I've done this before. Here are the steps I used:

[font="Courier New"]

source server = server from which backups originated

target server = server onto which we wish to restore the system...