sql shrink database

, status, you can observe the observation will be found, in fact, there are 0, 22 states, 0 is representative of idle, 2 for use. Never underestimate this state, which is important for shrinking a database log file. The reason that the log file can be shrunk is that the data at the end of the file is cleared so that the part of the space is freed, rather than escaping the tail to delete the contents of the header or the middle part of the file. The sh

ObjectiveOn a SharePoint server that has been running for more than 2 years, it is strange to find that Sharepoint_config's database files are getting bigger and larger and have reached 90 gigabytes, shrinking by 20 gigabytes, but recovering to 90 gigabytes of size a week later.Because of insufficient disk space, there are only 200GB size, there are a number of large and small sites to store photos, videos, documents, etc., so decided to study this pr

Tags: SQL Server--First query dbname_log in Sys.database_files name, here take xxx instead ofUse DBNameGOSELECT file_id, name from Sys.database_files;GO--the real contraction statement. SQL Server 2008 First changes the mode to Simple mode, then shrinks and then changes back to full mode.SE [Master]GOALTER DATABASE DBName SET RECOVERY simple with no_waitGOALTER

Tags: cannot record the way the research job log foreword file Sha ObjectiveOn the Sharepointserver, which has been implemented for more than 2 years, it is found that the Sharepoint_config database file is getting larger and bigger, has reached 90 GB, the contraction can reduce 20 GB, but will recover to 90 GB size after a week. is very strange.Because of insufficient disk space, there are only 200GB sizes. There are a number of large and small sites

Tags: run backup file management clears CTI Trunc set DBCC SQL2008 's shrink log due to SQL2008 's optimization of file and log management, the following statements can be run in SQL2005 but have been canceled in SQL2008: (SQL2005) Backuplog dnname withno_logGo Dump TransactionDnname withno_logGo UseDnnameDBCCShrinkfile (2) Go -------------------------------------------------------------- (SQL2008): In the SQL2008 to clear the log must be in simple m

Each file in the database can be reduced by deleting unused pages. Although the database engine will effectively reuse the space, it is necessary to shrink a file multiple times without the original size. Data and transaction log files can be reduced (shrunk ). You can manually contract database files in groups or sepa

file space is not reduced because the space is occupied. Note: The bulk-logged recovery model is consistent with the log processing method of the full recovery model. 1. Confirm the Recovery model The following is a recovery model that uses SQL Server Management Studio to check the database. 2. Full backup A full backup must be done before the log backup. Note: do not tick the "Copy backup only" opti

Delete duplicate records and save TABLE_NAME Records in #table_name SELECT DISTINCT * INTO #table_name table_name Delete from table_name SELECT * INTO table_name from #table_name drop table #table_name Related to this is the "SELECT INTO" option, which can be used in database properties dialog box, either hook up this item, or execute in Query Analyzer Execute sp_dboption ' db_name ', ' SELECT INTO ', ' true ' Open. The default value is off. *****

Label:CColorDialog Dlg; Dlg. DoModal (); M_crcurcolor = dlg. GetColor ();//colorref M_crcurcolor; BYTE r = getrvalue (M_crcurcolor); BYTE g = Getgvalue (M_crcurcolor); BYTE B = Getbvalue (M_crcurcolor); Database backup Declare @name varchar (250)EXEC Master. xp_cmdshell ' echo d:\ cd d:\ d: if not exist database MD database ' Set @name = ' D:\