Answered step by step
Verified Expert Solution
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!!!!
Create New Login
SQL server authentication
Login name should be "Faisal Mohammed
Password
and Confirm password
columns.
Create login yourloginname with password
'yourpassword'
Create login Testlogin with password
P@ssword'
Test the new created user login
in step
Now it is the time to test the newly created user login
above in step
is it working or not,
login with user name and password using SQL Server authentication
Create Database
Database name should be
CCDS
example
database with the name CCDS
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 No
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
and server
Log
file" as text file in submission,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started