Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Shrink log shrinks at 1 MB and sometimes don't
Message
 
À
15/07/2013 13:50:53
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01578446
Message ID:
01578463
Vues:
45
>>The autogrowth of the files you can set it in SSMS:
>>Right click on Database
>>Select Properties
>>Click on Files.
>>The you will see on the right part of the form "Autogrowth/Max size" column (I thing the Max Size is only in 2012, but I'm not sure).
>
>Thanks, I adjusted the Autogrowth by 1 MB. Then, I tried to set the initial size to 1 MB instead of 352. But, that value does not get saved. Even if I save it with 1, whenever I come back to that option, it says 352. On disk, this is the size of the file. Between those steps, I tried a shrink file but that doesn't change anything.

Try with SSMS:
Right Click on DB
Tasks->Shrink->Files
In the form choose "File type: LOG"
From option group "Reorganize pages before ...."
and then set File size to 0 (Zero) MB

Script:
USE [YourDBName]
GO
DBCC SHRINKFILE (N'NameOfTheLogFileHere' , 0)
GO
If both didn't help, then try to see why.
In your previous thread, the error have the info:
SELECT Name, log_reuse_wait_desc FROM sys.databases
WHERE Name = 'YourDBName'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform