While trying to identify a solution for an internal private cloud for a client and deploy SQL Server as a service on it, came across following articles which can provide some useful insight and references,   Microsoft provides certain case studies and articles at following link on private cloud, http://www.microsoft.com/en-us/sqlserver/solutions-technologies/hybrid-it/private-cloud.aspx   Microsoft with HP and Dell has provided Database consolidation and private cloud appliances as well, details at following link, http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-dca.aspx http://h71028.www7.hp.com/enterprise/us/en/partners/microsoft-database-consolidation-solution.html http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/13/announcing-the-first-database-consolidation-amp-private-cloud-appliance.aspx   If […]

Today found that soemone has delete log file of one of database and database was inaccessible, when tried to take it offline and then bring online received following error while bringing it online,   “Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details”   “The log cannot be rebuilt because the database was not clearly shutdown (Microsoft SQL Server, Error: 945)”     […]