I have a database server running several instances of database. I am having issues while accessing a particular database and want to restart the same but without restarting the entire db server as it will effect other databases in the instance or other instances on the same server.
Is there a to restart a single database using commandline or any other means?
Is detaching the database from server and attaching it back or taking it offline and bringing back online same as restarting that database?
Note: Just to add its a MSSQL 2005 server hosted on win2k3.