Scenario 5-1: Looking at SQL Server Security Your boss took a SQL course in coll

Question

Scenario 5-1: Looking at SQL Server Security

Your boss took a SQL course in college a few years ago. He asks if he can logon to the SQL server with the sa account so that he can look at the databases and run a few queries. Unfortunately, you tell him that the sa account is not available on the server. He wants to know why, and he wants to know what he can use to access the databases. What should you tell your boss?

Scenario 5-2: Using Full and Incremental Backups

You have six large databases, each being at least 2 GB. You need to make sure that you back up the databases each night in case you have a disaster and must recover them from backup. Because each database takes two hours to back up and you only have a six-hour window in which to do backups each day, what would you recommend as a backup solution?

From the book 98-364 MTA Database Administration Fundamentals chapter Five.... Thanks for the help

Explanation / Answer

sa account is by default disable in windows authentications, it needs to be manually enabled

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.