Script Sql Utili

ALTER DATABASE [DatabaseName] MODIFY FILE ( NAME = N'DATABASENAME_Log', SIZE = 512000KB , FILEGROWTH = 0)
 
ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(DatabaseNameLocico, 1)
ALTER DATABASE [DatabaseName] SET RECOVERY FULL WITH NO_WAIT
 

Add Feedback