Time
1 hour 40 minutes
Difficulty
Beginner
CEU/CPE
3

Video Description

Managing the Active Directory Domain Services Database This lesson covers managing the active directory domain services database. When many change are made in the active directory domain services database, it can become fragmented. This lesson covers how to defragment the active directory domain services database to optimize system performance and make it work at its highest efficiency. To accomplish this, do the following: - Stop the active directory services on a domain controller - Run utilities to run database maintenance Participants learn step by step instructions to defragment the active directory and can follow along with the instructor as he offers screen by screen instructions.

Video Transcription

00:16
we do a lot of frequent changes, deletes and moves. In our Atra directory database, we sometimes get a little bit of fragmentation, and things are are impacted in terms of health, things of process. It can have an impact on the performance. Obviously, of the actor director is done,
00:33
so we want to do from time to time is actually defragment that database or basically kind of cleaned it up
00:40
and get rid of all the legacy information that doesn't need to be there. So to do that, we actually need to do two things. First of all, we need to stop the actor Directory service is so the A. D. D s service is
00:51
on a domain controller and on that same time, a controller that we're gonna run our utilities to actually perform the database maintenance. So here we are, in our environment that we're actually have our server manager open. So the first thing we need to do is actually stop a D. D s. So there are tools menu,
01:07
if we go under our tools menu, actually find
01:11
our service is options. So I should go to choose Service's
01:15
Ed Wood will get our service is Council. Open up. We're gonna find our active directory. Do Maid Service is
01:22
service
01:23
ad. You could either hit stop over here of the leak, or you can right click on it and choose Stop
01:30
Bear in mind, will you do? This is going to say,
01:33
would a d. D s stops. You're gonna have to stop Curb Rose, Your key distribution center, k d c. We're gonna stop interstate messaging Deanna server D. F. S application.
01:44
Obviously, we need to stop all those to make sure that we get a clingy database de fragmentation. So we go ahead and click on Yes, to go ahead. Stop that. And go ahead, leave that window open, because when you're done with your
01:55
process, you're going to d do start the A. T. D. S service is back up, so I gotta leave that open because we're gonna come back to it, and then we're gonna go ahead and get over to our power shell environment. So in our power shell of our bit, which we've have under screen here was cleaning up, so we have
02:13
our power shall survive it. It were actually going to
02:15
now do what's necessary for us to
02:20
manage a database from a power cell environment because remembers offline. So we can't really made it from the gooey after for power shell. So are made utility for this is Auntie D s you till
02:31
So it's our utility. So Auntie D Sutil and you don't need to type in the daddy exits. Understood. So hit. Enter. But you could have it if you want
02:40
and it brings up our STDs You till that e x c prompt. So it tells us we're at the product
02:46
ad for us to do bait. It's We actually have to tell it
02:50
what we're gonna do, mate. It's on.
02:52
So in this particular case, we actually need to choose the after directory database if structure So we're gonna need to
02:58
activate.
02:59
There we go. Thio activated. Instance. So
03:01
our instance. And we could do it on that. Just are after director database. But we could do it on the radio, the S database the same way activate its *** and that it's ed t. D s because that's our main database environment.
03:15
And we had it, er it says okay.
03:17
Active instance set to NT d. S. You're so into DDS and we're back to our prom. Now. What we need to do is work on the next piece of the puzzle. So we're not We're actually
03:30
he involved in our actual and tedious database. So now issue would look at our
03:35
files here, So go ahead, do files. It says okay in the files. Made you the files category that says we have filed make this option. So we want to
03:45
I take a compact here, so we're going to
03:47
compact, right?
03:50
And what do we get? A compact
03:52
and where we're gonna cop attitude. So compact to write the root of C C C colon backslash.
03:58
That's what a compact to in terms of our environment at. Go ahead, innit? Inter get.
04:05
And here the source databases and Windows NT D s T d s died a d i t target database that C D d s. That d i t. Last year Tells us what our source database is the target and it tells us our d fragmentation status. It says percent complete. Tell you
04:23
it is recommended that you immediately perform a full backup of this data vase.
04:27
If you restore a backup made before the d fragmentation the database will be rolled back to the state. It was at the time of that backup. Pay attention to that. If you've done a maintenance on this, we need to do, Ah, backup of the NT D s or the 80 database Compact is successful. You need to
04:46
copy
04:46
the what you just did too.
04:49
The location the original was in and delete the old log files that area with his anti d s that log. So if you're gonna do that, that's what you have to do. So in this particular case is going to say if you have a contacted, we actually want to
05:05
verify before we do anything else right before we actually copy To think we have to go to verify the integrity of that offline database. Because basically, this is just an offline database at this point. So it's gonna verify the integrity by tapping and integrity as our command
05:19
it and enter is doing integrity. Check for the original database, check a database integrity and it completed your integrity. Check successful. It is recommended. You run semantic database analysis to assure semantic database consistency as well. So you could do that if you want, but it's not.
05:38
It's ah, something You certainly doing a production of our bit,
05:41
and that's to something that would actually benefit you. So obviously we know that we have our original database here, so basically, compact it at at this point, if we want to actually implement it, we actually have to copy the
05:56
locations over. So this particular case, if we copy it, we actually have to not only copy the NT d s that d i t from the root of sea or wherever we put it Doesn't enter the other Rudy See, to our NT d s d i t. It don't ever actually compact it to its own location. Always compact it to a separate location
06:15
that if we do
06:16
implement the change So if we take our contacted database and move it to our production database location, we need to make sure that all of the NT D S log files associated with the band compact of database are removed and the new log files are developed. After that, that obviously would We're done. We can actually, from a file maintenance standpoint,
06:36
say
06:38
we could go ahead, quit quit out of our file bait this? No, this is not exit. It's quick.
06:42
I had to get out of 80 issue till it's also the same command. It's quick. It's not Excellency. Hit. Quit. But that brings us back to our
06:49
made screen. Now get back to our main screen is only half the battle. Obviously, if we were going to do this in the production environment that we're gonna copy that database over What? Actually, we should make sure we copy it
07:00
over before we restart. Our active directory Debated service is so we'd want to do that. Copy a cleanup of the
07:08
log files first. Where Actually says we don't have a situation. We need to do it for our lab of our But obviously, if if you want to do it in your production of our bit that you would actually go into here's your see where you actually have your NTS. And you'd, uh, copy that, right?
07:26
And then you would go into your widows
07:29
and T. D s and what some people will do to be on the safe side. Right? So they get attendee at TGS here, they would take this one and they would read a bit as STDs that d I t that old Just have a back up. Just a case of that. After that, they would come in here and it would taste the copy that they have created.
07:46
If that's a route you want to go, we don't need to do that for its particular environment, but it's fairly straight forward. And when you're all done,
07:55
yes, you'd want to come in here and actually go back to your
07:58
starting of the 80. Debate Service is so you want to go ahead and click on start?
08:03
There you go. It starts the service back up.
08:07
And remember when we stopped it, it stopped. A whole bunch of service is.
08:11
So if we actually looked here, we stop again. There's the starts. Those service's were automatically stopped. So we're not gonna wanna stop. Those service is,
08:20
um unless we need to, so it'll stop it. We're going to go through the process here again to see it says Winters could not stop the e T tube. A service of local creator is not valid for this service. So you gotta be careful in terms of make sure you have everything. Really.
08:35
I had. A lot of people will tell you that if you're going to do a to clean up of this nature that after you're done cleaning it up us, you want to go ahead and reboot the server to make sure that everything it restarts in a clean of our bit.
08:50
And that's how we actually do basic maintenance on our actor director debate service's database or A D. D. S is done through the NT d Sutil.

Up Next

Microsoft Active Directory Domain Services

Module 2 explains how to implement virtualized domain controllers and read-only domain controller (RODCs)

Instructed By

Instructor Profile Image
Michael Boberg
CEO of Broadline Enterprises, LLC
Instructor