sql shrink database

1. Clear logsDump transaction database name with no_log 2. truncate transaction logs:Backup log library name with no_log 3. Compress database files (if not compressed, the database files will not be reducedEnterprise Manager -- Right-click the database you want to compress -- all tasks -- contract

Tags: manual ado An operation understanding data file settings. com colDatabase shrinkage:Personal understanding, the database in the process of ordinary long-term operation of the log files will always be in a certain proportion in the increase, data files in the database after deleting a large amount of data does not necessarily reduce disk space, repeated operations will appear wasted space, so the shrin

Label:Recently discovered Web sites are inaccessible because the database server disk has no more space left. The log file was found to be 70%, and shrinking the log file failed.The reason for the online lookup is that no backup cannot shrink the log file.A temporary solution:Back up the transaction log, and then shrink the log file. (You can also

/*------------------------------------------------------------------ -- Author: htl258 (Tony) -- Date: 2010-04-16 14:30:23 -- Version: Microsoft SQL Server 2008 (RTM)-10.0.1600.22 (Intel x86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 5.1 ------------------------------------------------------------------*/ Use Tony Go Alter database Tony set recovery

Recently the company's database as the volume of business increased, the log file is huge (more than 300G), resulting in insufficient disk space, and subsequent access to the database request can not be accessed.There are a lot of similar methods on the Internet, but they are not feasible, as I have done, and it works, to shrink the log file to any specified size

Tags: transaction database One serve nbsp simple SQL size. DataToday, according to the usual method of shrinking a test database log, found unable to shrink!dbcc sqlperf(logspace)Use [Dbname]go ALTER DATABASE [dbname] SET RECOVERY simple with no_waitgodbcc shrinkfile (N ' Db

Tag: SQL Server database log shrinks free space.How SQL Server database shrinks log spaceDescription: SQL Server database log will become larger, especially when the space is tight, you have to

Problem: The actual size of the database is 600MB, the actual size of the log file is 33MB, but the log files occupy space for 2.8gb! tried a variety of ways, shirnk DATABASE, TRUNCATE log file, there is no way to reduce the files. Anyway, this should be a bug in SQL Server. Workaround: Then find the following code, you can reduce the log file to the size you wan

operation; All DB files, including data files and log files, are shrunk (Shrink database data files Shrink database log file); The user executing the SQL script needs to have the dbo permissions of the sysadmin or the associated

Tags: style color ar using SP strong file data onSQL Server allows the user to set the database initial and maximum values, which can be configured by auto-grow or auto-shrink. With these configurations, we can prevent application modifications that could be caused by database space problems, or when SQL Server disk sp

Why don't you shrink the database file (foreign translation) and the database translation? Preface: I have read a lot of articles about SQL server shrinking data files over the past few days. I am going to write an article about shrinking logs, but suddenly there was an impulse to translate the classic article. The fol

1, set the database mode to Simple mode: Open SQL Enterprise Manager, in the console root in turn, click the Microsoft SQL Server-->sql Server group--> double hit Open your server--> double-click to open the database directory--> Select your

1. Online segment shrink recycles idle space that uses fragments below the high water level line in the Oracle database segment. Segment shrink has the following benefits: 1. compressed data will lead to better cache utilization, resulting in better online transaction processing (OLTP) performance. 2. During full table scan, fewer blocks are required for shrinkin

/*--Special attentionPlease follow the steps, do not take the previous steps, please do not follow the stepsFailure to do so may damage your database.--*/1. Clear the LogDUMP TRANSACTION Library name with NO_LOG2. Truncate the transaction log:BACKUP LOG database name with NO_LOG3. Shrink the database file (if not compr

Original: http://blog.csdn.net/tjvictor/article/details/5253931?when SQL Server when the transaction log is truncated, it simply marks the virtual log file so that it is no longer used, and then prepares it for reuse as a backup ( if carried in a full or bulk log recovery model ) . In other words, when using the simple recovery model, the transaction log includes the following logging: when Span style= "COLOR: #336699" >checkpoint 1 2 1 , 2

CatalogueWhat is a transaction logComposition of the transaction logTransaction log Size Maintenance methodsTruncateShrinkIndex fragmentationSummarizeWhat is a transaction logTransaction Log is a record of a series of actions performed on a database management system and uses these records to ensure acid availability in the event of a hardware failure or disaster. Physically, the transaction log is a file that records the update operations on the data

Tags: c blog http a int widthHow SQL Server truncates (Truncate) and shrinks (Shrink) transaction log classifications: SQL Server database backup restore 2010-01-25 14:321,708 people read comments (4) ReportWhen SQL Server truncates the transaction log, it simply marks the v

Tags: task error Resolution does not resolve information Shu nbsp strongSQL server2008 cannot shrink the log, the error message is: 1: Unable to shrink log file due to minimum log space requirements 2: Unable to shrink log file 2 (Xxx_log) because the logical log file at the end of the file is in use Describe: Used to be a common online shrinkage codeUse [master]

Original: SQL Server Enterprise Platform Management Practice reading Notes--sql Server How to set autogrow and auto-shrink itemsSQL Server allows the user to set the database initial and maximum values, which can be configured by auto-grow or auto-shrink. With these configur