SQL2000: Shrink DataBase and Truncate Log
Небольшой пример, как можно сжать(Shrink) базу данных в и обрезать журнал транзакций Все в Microsoft SQL2000 Будет полезно для начинающих ...
a shrinkdatabase - Academic - Data BasyX
Shrink Operation Fails on Microsoft SQL Server 2000 Database
As you store more and more data to your Microsoft SQL Server database, the size of database increases and the performance of Microsoft SQL Server decreases day by day. As a practical example of this behavior, you may come across the following error message when you try to reduce size of the SQL Server 2000 database using SHRINKFILE, SHRINKDB, or SQL Server Enterprise Manager:. At this point, if database corruption occurs, SQL database repair becomes need of hour. Large size of database may also cause system crash and sometimes database corruption....
a shrinkdatabase - Bookshelf
|
608 pages |
MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide, Exam 70-228 While this would not shrink the database at all, the statement would complete ... When using a SHRINKDATABASE or SHRINKFILE statement, it is important to ... |
|
499 pages |
Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook Select Tasks, Shrink, and Database (select Files to shrink an individual file). ... The SQL Server Enterprise Manager Shrink Database dialog box is shown in ... |
|
784 pages |
Accelerated SQL Server 2008 REORGANIZE fortable and view indexes Performs a shrink database command if certain parameters such as database size are met Performs an update of statistics ... |
|
674 pages |
Pro SQL Server 2005 .REORGANIZE for table and view indexes Shrink database Performs a shrink database command if certain parameters such as database ... |
|
576 pages |
Silverlight 4, Problem - Design - Solution Figures 12-8 and 12-9 show the full list of tools including a backup utility, database restoration tool, attach data file, and a shrink database tool. 5. ... |
a shrinkdatabase - News
|
Alcuni motivi per evitare lo shrink di un database L'operazione di shrink può essere effettuata in SQL con il comando DBCC SHRINKDATABASE, che consente di compattare i dati ei file di log di un database specifico, oppure con il comando DBCC SHRINKFILE, che permette di ridurre la dimensione di un file |