Wednesday, September 30, 2015

Creating copy of existing SQL Server for development or testing purpose

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 

1 comment:

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...