Installation :
Install .NET frame work 3.5
Install SQL Server 2012
Applied latest Service pack 2(Restart)
Copy-Restore the databases from server X to Server Y
Changed all databases compatibility to 110
DB mail:
Configure Database Mail, SQL Operator, Configure Mail
profiles to SQL Agent , Restart SQL Agent
Logins/Users:
Create necessary logins,users and check if any orphan users
sa with strong password
Jobs:
Created Backup Jobs to run Daily 11am(purge backups older
than 2 days)
Rebuild indexes
Update Statistics
Created Space alert Job
Linked Servers:
create if needed any
It's so nice article thank you for sharing a valuable content. SQL server dba Online Training Bangalore
ReplyDelete