Temporarly Disable Database - SQL Management Studio Express

I was given a laptop and it has sql server installed and a bunch of DB's from the old user, I dont want to delete the db, I just want to temporarly make them unavailable.

LVL 14
B_DorseyAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
ALTER DATABASE db_name SET OFFLINE;
http://msdn2.microsoft.com/en-us/library/ms174269.aspx
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
alternative, if you want to completely remove them from the list of database, but keep the files:
detach them (you can attach the database later).
I would prefer the OFFLINE, though...
0
 
B_DorseyAuthor Commented:
so htere is no way to just remove read/write permissions? For example I see the northwnd db in there and can access it...
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>so htere is no way to just remove read/write permissions?
you could assign the roles db_denydatareader / db_denydatawriter to all the users in the database...
it depends on what exactly you are trying to achieve...
0
 
B_DorseyAuthor Commented:
i just dont want someone trying to access the data, there are other machines that access the data on that laptop and I wanna stop that and have them approach me to find out what applications are flying around that are dependant on this thing...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
so, indeed ensure you put correct logins and appropriate user permissions.
if a login has no mapping in a database (ie a user), that login can do NOTHING in that database.
0
 
B_DorseyAuthor Commented:
sorry for making u go through all this, I think I just want to set offline

thanks for your help

b
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.