Command SQL
ALTER DATABASE [YourDatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKDATABASE ([YourDatabaseName], 1, TRUNCATEONLY)
ALTER DATABASE [YourDatabaseName] SET RECOVERY FULL WITH NO_WAIT
Source :http://www.delahaye.fr/sql-reduire-fichier-de-log-ldf/
0 commentaire