If you already have log shipping setup, then you just need to:

1. Restore all the tran log backups from the primary to the secondary

2. Backup the tran log on the...

This msdn article should give you all the info you need to failover.

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

Microsoft has a KB article

http://support.microsoft.com/kb/909967

An example of when you "have" to use it would be a requirement from a 3rd party. SAP requires xp_cmdshell be enabled and permission to execute it be granted to...

After enabling the mail profile in SQL Agent, you need to restart SQL Agent. A restart of SQL Agent should resolve your issue.

Yuri55 (9/28/2011)

---

Jeremy,

Sorry, but frankly I confused with your recommendation "Keep the witness in the same site as your principal database"

(and certainly I know that per BOL MS "We strongly recommend...

No, there needs to be a quorum for automatic failover to happen....

Keep the witness in the same site as your principal database. If the principal loses connection with both the witness and the mirror the principal database will become unavailable. This...

I double checked in SSMS 2008R2 and it appears correct, however, if...

Guess it needs the line feed also. This should do it.

select 'USE ['+name +']' + CHAR(13)+CHAR(10)+'GO'+ CHAR(13)+CHAR(10)+

'CREATE USER [abc\scott] FOR LOGIN [abc\scott]'+ CHAR(13)+CHAR(10)+'GO'+ CHAR(13)+CHAR(10)+

'USE ['+name +']' + CHAR(13)+CHAR(10)+'GO'+ CHAR(13)+CHAR(10)+

'EXEC sp_addrolemember...

CHAR(13) is used for carriage return.

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

select 'USE ['+name +']' + CHAR(13)+'GO'+ CHAR(13)+

'CREATE USER [abc\scott] FROM LOGIN [abc\scott]'+ CHAR(13)+'GO'+ CHAR(13)+

'USE ['+name +']' + CHAR(13)+'GO'+ CHAR(13)+

'EXEC sp_addrolemember N''db_owner'',N''abc\scott''' + CHAR(13)+'GO'+ CHAR(13)

FROM sys.databases

WHERE database_id>4

Run the above with results...

Was the SQL Agent restarted after the db mail profile was enabled for it? If not, you should see something like "An attempt was made to send an email when...

In SQL 2008 they are located in ReportServer.dbo.DataSource

Here is a pretty thorough guide to migrating from 2005 to 2008.

http://technet.microsoft.com/en-us/library/ms143724.aspx

I've seen this with Quest Spotlight as well.