Wednesday, March 7, 2012

Alter Database Emergency

I currently have a SUSPECT database which I need to put into EMERGENCY mode. Apparently, in SQL Server 2005, I need to do this using an Alter Database command.
Does anybody have the syntax or an example?

ALTER DATABASE [dbname] SET EMERGENCY

GO

No comments:

Post a Comment