如何在紧急模式下设置数据库？

my database is stoped. i can't make anything, select, update, nothing. somebody told me to set the database in emergency mode but i don't know how?

我的数据库已停止。我做不了什么,选择,更新,没有。有人告诉我在紧急模式下设置数据库,但我不知道如何?

4 个解决方案

#1

i found the solution : ALTER DATABASE dbName SET Emergency

我找到了解决方案:ALTER DATABASE dbName SET Emergency

#2

i think this is only for Server DB, or not?

我认为这只适用于服务器数据库,不是吗?

in SQL Documentation was a query like this:

在SQL文档中是这样的查询:

set emergency mode "databasename"

try it on! cos' I have only Express Edition of SQL Server here

试试! cos'我这里只有SQL Server的Express Edition

#3

If your databse is in suspect mode, you will have to keep that database in emergencey mode (to gain acesses to that DB).

如果您的数据库处于可疑模式,则必须将该数据库保持在emery模式(以获得对该数据库的访问)。

alter database datasename set emergency

Then run DBCC statement as:

然后运行DBCC语句:

dbcc chedkdb(DBname,repair_rebuild) with no_infomsgs

If this doesnt work ,then keep the DB in singleuser mode like below and run checkdb statement

如果这不起作用,那么将DB保持在单用户模式,如下所示并运行checkdb语句

alter database DBname set single_user
dbcc checkdb(DBname,repair_allow_data_loss) with no_infomsgs

If that succeeds,now keep the DB online by

如果成功,现在将数据库保持在线状态

alter database DBname set multi_user

#4

-1

USE [master] GO
-- Method 1: I use this method
EXEC sp_attach_single_file_db @dbname='TestDb',
@physname=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf'
GO
-- Method 2:
CREATE DATABASE TestDb ON
(FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf')
FOR ATTACH_REBUILD_LOG
GO

#1