Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part2 - SQL Server DBA Tutorial

In this video you will learn following as part of Upgrade of SQL Server 2008R2 to SQL Server 2012,
1- How to take backup of user databases using backup maintenance plan
2- How to change location of databases backups storage
3- How to execute maintenance plan to take full backup of user databases
4- How to script out Logins on SQL Server 2008R2
5- How to transfer logins from SQL Server 2008R2 to SQL Server 2012
6- How to save T-SQL output in .sql format
7- How to script server role if it exist
8- How to script out Credentials in SQL Server 2008R2
9- How to script out Server Audit and Server Audit Specifications
10- How to script backup devices in SQL Server 2008R2
11- How to script out endpoints if they exist
12- How to look at Mirroring information using system views
13- How to script out Linked server in SQL Server 2008R2
14- How to script out Server level Triggers in SQL Server 2008R2
15- How to Script out Replication in SQL Server 2008R2
16- How to View DBMail Configuration in SQL Server 2008R2

Click here for Part 3



Upgrade of SQL Server 2008 R2 to SQL Server 2012 - SQL Server DBA Tutorial