How to setup Database Mail in Microsoft SQL Server 2008 R2.

1. Enable and configure Email
2. Create Profile and Account
3. Configure Email.

USE master
GO

EXEC sp_configure ‘show advanced’, 1
GO
RECONFIGURE
GO

EXEC sp_configure ‘Database Mail XPs’, 1
GO

RECONFIGURE WITH OVERRIDE
GO

1. Open SQL Server Management Studio –>Expand Management Node —> Right click Database Mail —> Select Configure Database Mail.

Click Add

Click Next

Click Next

Click Next

Click Finish to complete the setup

T-SQL script find SQL Server Recovery Model

SELECT name AS [Database Name],
recovery_model_desc AS [Recovery Model]
FROM sys.databases
GO