Msg 2540 means the system cannot self repair this error, usually corrupt metadata or system files. My fix order: restore the backup, DBCC repair, check hardware.
SQL SERVER – T-SQL Script to Attach and Detach Database
Detach Database operations remove a database from its instance without deleting its files. I preserve a recoverable backup before moving them.
SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.
Index Maintenance on Modern Storage
Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.
Data Types That Waste Space
Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
At MIS2007 we had a database RAID discussion: RAID 5 or RAID 10 for databases from 5 GB to 5 TB. Almost everyone picked RAID 10, even though it costs more.