var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: stop one sql server database
We have a web applicaiton backend database uses sql server. Now we stop using this web application. I would like to stop this sql server database. What do you usually do? I can backup this database and delete this database. Or if i want to keep this database. What should i do?
Thanks for you help.
ou don't stop a database, you stop a server
You can put the database in Single User mode, and/or make it read only
Or you can rename the database.
Why not just disable the application code?
i stop the application. but my boss still doesn't want other people access the data.
One more question. Why stop the server? I don't understand.
Thanks. I will try those way you gave to me.
Then revoke the access except to the admins
Originally Posted by
All I'm saying is you stop a server, not a database...I wouldn't reccomend doing that though
One more question. Why stop the server?
I guess you want to remove permissions and noone except the admins can see the database..I think that's what you want
When was the last time you did a backup btw?
alter database BLAH set offline
I will do backup now. If you take the database off line. Does that mean you won't see in the enterprise management? But the database still there, you can't access it? Am i right?
The database will be grayed out and unavailable in Enterprise manager. Attempting to access it may give you errors, but no access.
Thanks a lot. Have a nice day!