Email this page
Send a link

MSSQL



How to enable sending mails from SQL server

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO


Restore from full and then differential backup

First, remember to restore the full backup with this option! Very important!
Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)

Then restore the differential backup with default option
RESTORE WITH RECOVERY


How to kill connections manually

Use sp_who and kill the IDs.
This also makes it possible to rename a database, when no connections are active (very handy).