Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You needed to upgrade an existing application that requires a higher version of SQL Server Instance. Write down the missing two steps you need to

You needed to upgrade an existing application that requires a higher version of SQL Server Instance. Write down the missing two steps you need to execute during a database level upgrade.
Note: The database is in full recovery mode and currently sitting on SQL Server 2012 and the target server is SQL Server 2017.
Use sp_helplogins to generate the logins related to the database to be migrated
Restore full backup, differential backup and transaction log backup with no recovery model
Stop the application
Take a tail log backup
Set the database compatibility mode
Repoint the application to the new server in short answers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Security

Authors: Alfred Basta, Melissa Zgola

1st Edition

1435453905, 978-1435453906

More Books

Students also viewed these Databases questions

Question

How is risk measured in a market economy? AppendixLO1

Answered: 1 week ago