how much server space cost

1 UseMaster2 Go3 Select * fromsys.dm_os_buffer_descriptors4 Go5 6 --View the amount of space the database occupies in the data cache7 --128 Bytes, 1/8 kilobytes (KB) because each data page corresponds to a row in dynamic management view (management VIEW,DMV)8 --1 byte (byte) = 8 bit (bit)9 --1000 kilobytes (KB) = 1024 bytes (byte)Ten --1 megabytes (MB) = 1.024 million kilobytes (KB) One Select Count(*)*8/1024x768 as 'Cached Size (MB)', A Ca

then replace the data file of the new library with the attached failed data file, and then set the database as the Emergency Recovery mode, so that the data can be read in generalALTER DATABASE db_name SET EMERGENCYAfter the database can be read, you can try to set it to ONLINE mode, if successful, then DBCC CHECKDB once, confirm no problemIf you can't online, you probably have to create a new library and then take the data from the contingency mode library to the new library.Special Note: The

Tags: har status next declare sed for DEA etc beginCREATE TABLE #Data(Name VARCHAR (100),Row VARCHAR (100),Reserved VARCHAR (100),Data VARCHAR (100),Index_size VARCHAR (100),Unused VARCHAR (100));DECLARE @name VARCHAR (100);DECLARE cur CURSOR forSELECT NameFrom sysobjectsWHERE xtype = ' u 'ORDER by name;OPEN cur;FETCH NEXT from curinto @name;While @ @fetch_status = 0BEGININSERT into #DataEXEC sp_spaceused @name;PRINT @name;FETCH NEXT from curinto @name;END;CLOSE cur;DEALLOCATE cur;CREATE TABLE #