Option 3: Enter the maximum percentage of free space to be left in the database file after the database has been shrunk. The value can be between 0 and This option is only available when Reorganize files before releasing unused space is enabled. But if we prepare to delete data, the primary data file cannot be made smaller than the size of the primary file in the model database. Option 4: Select the Empty file by migrating the data to other files in the same filegroup check box.
Expand Databases , right-click it from which to delete the file, and then click Properties. Select the Files page. In the Database files grid, select the file to delete and then click Remove. Copy and paste the following example into the query window and click Execute. This example removes the file test1dat4. But command can work fast. In a word, they can shrink and then delete database file or log file. The difference is just the implementation.
For Windows. Data Recovery. Products Articles. Ask Question. Asked 8 years, 4 months ago. Active 6 years, 4 months ago.
Viewed 5k times. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Satinder singh Satinder singh 9, 16 16 gold badges 55 55 silver badges 96 96 bronze badges. Torben Schramme Torben Schramme 1, 1 1 gold badge 14 14 silver badges 25 25 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back
0コメント