SQL2000: Shrink DataBase and Truncate Log
Небольшой пример, как можно сжать(Shrink) базу данных в и обрезать журнал транзакций Все в Microsoft SQL2000 Будет полезно для начинающих ...
Небольшой пример, как можно сжать(Shrink) базу данных в и обрезать журнал транзакций Все в Microsoft SQL2000 Будет полезно для начинающих ...
In my example, I executed sp_helpfile system stored procedure in pubs database to get current database files information (logical file name and size is important). First, I need to get the get the information about the current database file, specially the logical file name, which should be shrunk by executing sp_helpfile stored procedure. file_name , Is the logical name of the file to be shrunk....
|
464 pages |
The SQL Server 7.0 handbook, a guide to Microsoft database computing O Select All Tasks and Shrink Database. ■=> Select the desired options. O Click OK. The SQL Server Enterprise Manager Shrink Database dialog box is shown ... |
|
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 ... |
|
548 pages |
Pro SQL Server 2005 Integration Services Shrink Database The Shrink Database Task performs a shrink on a SQL Server database's data ... A shrink operation reduces the amount of free space—that is, ... |
|
570 pages |
Hands-on Microsoft SQL server 2005 integration services Shrink Database Task This task runs the DBCC SHRINKDATABASE T-SQL command to shrink the specified database. The step by step configuration process goes like ... |
|
|
Inside Microsoft® SQL ServerTM 2005: The Storage Engine DBCC SHRINKDATABASE (database_name [, target_percent] [, {NOTRUNCATE | TRUNCATEONLY} ] ) DBCC SHRINKFILE DBCC SHRINKFILE allows you to shrink files in the ... |