The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive

Error The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run. Error: 927, Severity: 14, State: 2. Database ‘model’ cannot be opened. It is in the middle of a restore. Could not create tempdb. You may not have enough disk space available. Free additional disk space…

4

SQLServer: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16

SQLServer2008: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16 SQL Server 2012 : Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’  SQL Server 2008 instance fails to start or hangs after service pack or Cumulative update installation.   A newer version of…

2

Configuring SSL for SQL Server using Microsoft Certificate Authority Server

Configuring SSL for SQL Server using Microsoft Certificate Authority Server  Refer attached document  for detailed steps  1. Install IIS Server from ADD/Remove Windows Components (if it is not installed already) 2. Install Certificate Server ADD/Remove Windows Components (if it is not installed already) 3. OPEN Certsrv browser console by either of below mentioned ways,  …

0

SQLServer 2008 Fails to come online on cluster after upgrade

SQL-Server 2008 Fails to come online on cluster after upgrade.   Reason: Server is in script upgrade mode. Only administrator can connect at this time.   Login failed for user ‘ccccc\xxxxx. Reason: Server is in script upgrade mode. Only administrator can connect at this time.     Issue: SQL-Server 2008 Fails to come online on…

1

How to Analyze "Deadlocked Schedulers" Dumps?

How to Analyze "Deadlocked Schedulers" Dumps? Newer version of this post is available in http://mssqlwiki.com/2010/06/15/how-to-analyze-deadlocked-schedulers-dumps/ Do you see "Deadlocked Schedulers" errors similar to one below and stuck? From SQLServer Errorlog **Dump thread – spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt * BEGIN STACK DUMP:…

4

We do not see the SQL server and SQL Agent status from management studio. When we right click the instance, start, stop and resume options is disabled.

From  management studio we do not see the SQL server and SQL Agent status. When we right click the instance, start, stop and resume options is disabled.     WMI Permission could be a cause. Enable below permission in WMI.   1) –Open Dcomcnfg –Expand Component Service -> Computers -> My computer –Right-click and go…

1

DBCC CheckDB fails with error "The database could not be checked as a database snapshot could not be created and the database or table could not be locked"

DBCC CheckDB may with fail with error Error Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation. Msg 7926, Level 16, State 1, Line 1 Check statement aborted. The database could not be checked as a database snapshot could not be created and the database…

1