piszczynski>Aleks (Created page with " == SQL Databases == Space can be cleared from databases using the shrink database option If desperate you can change the backup type of the database to "simple" then in th...") |
piszczynski>Aleks |
||
| Line 4: | Line 4: | ||
Space can be cleared from databases using the shrink database option | Space can be cleared from databases using the shrink database option | ||
Right click database > tasks > shrink > Database | |||
You can do the same for the files option then select log if you need to clear space for the log file | |||
If desperate you can change the backup type of the database to "simple" then in the shrink files section select log file and then In Shrink action choose Reorganize pages before releasing unused space, set the desired size of the file and then click OK. After action is completed you can change backup to full and perform a backup as previous backups will not be ale to restore to the current state of the database. | If desperate you can change the backup type of the database to "simple" then in the shrink files section select log file and then In Shrink action choose Reorganize pages before releasing unused space, set the desired size of the file and then click OK. After action is completed you can change backup to full and perform a backup as previous backups will not be ale to restore to the current state of the database. | ||
Revision as of 15:44, 1 July 2020
SQL Databases
Space can be cleared from databases using the shrink database option
Right click database > tasks > shrink > Database
You can do the same for the files option then select log if you need to clear space for the log file
If desperate you can change the backup type of the database to "simple" then in the shrink files section select log file and then In Shrink action choose Reorganize pages before releasing unused space, set the desired size of the file and then click OK. After action is completed you can change backup to full and perform a backup as previous backups will not be ale to restore to the current state of the database.