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

preview_player
Показать описание
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

Blog post link for this video
Рекомендации по теме
Комментарии
Автор

Hi, were can I get this script "How to script out Logins on SQL Server 2008R2"

BubbaNeeta
Автор

Hi,
How to migrate system database from 2008R2 to SQL Server 2012.

ericchen
Автор

Hi,

Can you place the login script in your blog. It will be helpful. Thanks in advance

fahamithaparveen
Автор

@TechBrothersIT - Thanks for the video. Really helpful. Could you please place the logins script in your blog site. Thanks in advance.

fahamithaparveen