Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2014-04-07 : 01:10:47
|
| Any advantage for setting database offline regarding server performance?I have number of databases on my server which are not in use.So just thinking if there is any performance gain if i set them offline or notKamran ShahidPrinciple Engineer Development(MCSD.Net,MCPD.net) |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-04-07 : 08:55:04
|
| If they are completely inactive, there is no special benefit one way or the other. There may be some slight cost benefits one way or the other when looking up system tables for specific databases etc., but I think those would be miniscule. But, the database may be accessed for reasons other than user activity - for example, if your backup plans include backing up "all databases" rather than "specific databases", you may be backing up the inactive databases at every scheduled backup.For such reasons, and just so my server will be clean, if I know I don't need a database, I take a final backup, make sure that I can restore it, keep the backup in a safe place, and then drop the database from the server. |
 |
|
|
|
|
|
Any advantage for setting database offline regardi