The database 'model' is marked RESTORING and is in a state that does not allow r

[Leshami]

如题，sqlserver 2008 + Windows 2008
2012-12-10 10:12:10.73 spid10s Database 'model' cannot be opened. It is in the middle of a restore.
2012-12-10 10:12:10.74 spid10s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.

磁盘空间是足够的，貌似是由于model数据库不能open,导致tempdb无法创建，请大家支招，谢谢！

[Leshami]

使用下面的方法启动之后， Sqlservr.exe -T3608 -c -f -T3609 出现下面提示： 2012-12-10 13:47:17.05 Logon Login failed for user '2GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 应该来时是支持单用户连接模式， 但是 C:\Users\sqlserver_setup>sqlcmd -E -S ADMIN HResult 0x35, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [53]. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific erro r has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

[kingtiy]

重启下数据库服务试下

[Leshami]

就是重启失败

[开启时代]

重启无效的话 ，只能修复数据库 'model'

[Leshami]

C:\Users\sqlserver_setup>SQLCMD -E -S ADMIN:sqlserver\local HResult 0xFFFFFFFF, Level 16, State 1 SQL Server Network Interfaces: An error occurred while obtaining the dedicated administrator connect ion (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number [x FFFFFFFF]. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific erro r has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

[Leshami]

lixzhong ： 这个sqlcmd的写法好像不对是吗？

[Leshami]

sql server browser 是处于started状态。

[黄_瓜]

try http://support.microsoft.com/kb/822852

[Leshami]

版主，你好， 根据你的链接，现在还是不能登录到 3.Start SQL Query Analyzer

[Leshami]

这个是使用sqlservr -c -m -T3608 -T4022 命令后的日志文件， 2012-12-10 11:02:48.90 Server Dedicated admin connection support was established for listening locally on port 1434. 2012-12-10 11:02:48.91 Server The SQL Server Network Interface library could not register the S ervice Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to registe r an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in formational message. Further action is only required if Kerberos authentication is required by authe ntication policies. 2012-12-10 11:02:48.91 Server SQL Server is now ready for client connections. This is an inform ational message; no user action is required. 2012-12-10 11:02:49.00 spid51 Starting up database 'Tfs_Configuration'. 2012-12-10 11:02:49.01 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.01 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.02 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.02 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.03 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.03 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.04 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.04 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.23 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.23 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.27 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.27 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.28 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.28 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.37 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.37 Logon Login failed for user 'GOTECH\SQLSERVER_SERVICE'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.66] 2012-12-10 11:02:49.41 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.41 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.43 Logon Error: 18461, Severity: 14, State: 1. 2012-12-10 11:02:49.43 Logon Login failed for user 'GOTECH\MOSS_SETUP'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: 192.168.1.165] 2012-12-10 11:02:49.98 spid51 Snapshot isolation or read committed snapshot is not available in database 'Tfs_Configuration' because SQL Server was started with one or more undocumented trace fla gs that prevent enabling database for versioning. Transaction started with snapshot isolation will f ail and a query running under read committed snapshot will succeed but will resort back to lock base d read committed. 2012-12-10 11:02:49.99 spid51 Recovery is writing a checkpoint in database 'Tfs_Configuration' (26). This is an informational message only. No user action is required. 2012-12-10 11:02:50.31 spid51 Clearing tempdb database. 2012-12-10 11:02:50.32 spid51 Could not create tempdb. You may not have enough disk space avail able. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Se rver. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized. 2012-12-10 11:02:50.32 spid51 SQL Trace was stopped due to server shutdown. Trace ID = '1'. Thi s is an informational message only; no user action is required.