Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help using oracle sql developer pleasa provide screenshots!!!! 1 - Create New Login ( SQL server authentication ) Login name should be Faisal Mohammed

need help using oracle sql developer pleasa provide screenshots!!!!
1
-
Create New Login
(
SQL server authentication
)
Login name should be "Faisal Mohammed
|
"
,
Password
"
1
2
3
"
and Confirm password
columns.
Create login yourloginname with password
=
'yourpassword'
Create login Testlogin with password
=
'
P@ssword'
2
-
Test the new created user login
(
in step
1
)
Now it is the time to test the newly created user login
(
above in step
1
)
,
is it working or not,
login with user name and password using SQL Server authentication
3
-
Create Database
Database name should be
"
CCDS
4
3
5
"
example
(
database with the name CCDS
4
3
5
)
4
-
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.
5
-
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
6
-
Restoring Database
Restore the database using Backup file we create above in step No
3
.
7
-
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,

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

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

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

Detailed note on the contributions of F.W.Taylor

Answered: 1 week ago

Question

What magazine and ads did you choose to examine?

Answered: 1 week ago