Dropping Databases and logins

Question

Dropping Databases and logins

Jpotucek

SSCoach

Points: 18583
More actions
January 3, 2006 at 11:29 am

#91154

I've been reading about dropping DBs and Users.. and I'm not sure which order you would do this in.
I have a DR instance that I would like to cleanup so that I can run my DR scripts again and test. my questions are:
Is it best to drop the Logins from Master and THEN drop the Databases? Do I drop the logins from Master or from their Default DB?
I'm thinking that I will drop the Users from Master and then drop the Databases... anyone have any thoughts?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 1

That sounds about right. Either way if you drop the DB they will not be able to access it. Now if that login is used in multiple DB's then I would run a profiler to see how much that log in is used before blowing it away.

Jpotucek SSCoach Points: 18583 More actions · Answer 2

Thanks! I{'m not worried about blowing away the DBs or logins - I just didn't want to create a mess doing things in the wrong order since I will be blowing away and recreating the DBs and Logins mulitple times.

Ian Yates SSCoach Points: 19738 More actions · Answer 3

It shouldn't matter what order you do things in. A "login" in SQL is mapped to a "user" in a DB (or is it the other way around? ). Probably makes the most sense logically to drop the DB(s) and then the login(s), especially if you use the login for other DBs...