Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help using oracle sql developer please please provide screenshots of each step!!!! Create New Login ( SQL server authentication ) Login name should

i need help using oracle sql developer please please provide screenshots of each step!!!!
Create New Login (SQL server authentication)
Login name should be "Faisal Mohammed|", Password "123" and Confirm password
columns.
Create login yourloginname with password='yourpassword'
Create login Testlogin with password='P@ssword'
Test the new created user login (in step1)
Now it is the time to test the newly created user login (above in step1), is it working or not,
login with user name and password using SQL Server authentication. Create Database
Database name should be "CCDS435" example (database with the name CCDS435)
Creating database backups.
Select backup type (Full\diff\log) and make sure to check destination path which is where
the backup file will be created.
Drop database
To remove your database from MS SQL Server.
Click OK to remove the database (in this example, the name is Testdb as shown in
the above screen) from MS SQL Server
Restoring Database
Restore the database using Backup file we create above in step No3.
Checking SQL Server logs and Export SQL Server logs.
Export SQL server logs file in Text Document (.log)
Important Note: Attach the Sereen Shots of all above tasks (1-7) and server .Log
file" as text file in submission,
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions