Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL Server log file truncate - Source :NAYCode.com

//****************** Source - NAYCode.com
ALTER DATABASE DATBASE_NAME
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (LOG_FILE_NAME_log, size in MB)
GO
ALTER DATABASE DATBASE_NAME
SET RECOVERY FULL
Comment

Reduce size of SQL server log file truncate - Source :NAYCode.com


ALTER DATABASE db5
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (adb5_log,10)
GO
ALTER DATABASE db5
SET RECOVERY FULL
Comment

Reduce size of SQL server log file truncate - Source :NAYCode.com

ALTER DATABASE DATBASE_NAME
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (LOG_FILE_NAME_log, size in MB)
GO
ALTER DATABASE DATBASE_NAME
SET RECOVERY FULL
Comment
PREVIOUS NEXT
Code Example
Sql :: Prepared statements in mysql 
Sql :: get item by composite primary key mysql 
Sql :: what i ssql 
Sql :: How to insert NULL value in MySQL 
Sql :: pl sql fetch 
Sql :: conditional index in postgres 
Sql :: mariadb set vertical output format 
Sql :: ring MySQL store binary data and special characters in the database after processing 
Sql :: check constraint is violated 
Sql :: sql set devault value with existing column 
Sql :: MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table) 
Sql :: How to Alter column in SQL Server - NAYCode.com 
Sql :: groupby sort sql hive 
Sql :: set mysql socket file docker windows 
Sql :: distinct 
Sql :: sql to c# linq converter online 
Sql :: sql include rows with 0 values 
Sql :: umgebungsvariable setzen für mysql 8 
Sql :: What is the difference between the LIKE and REGEXP operators in mysql? 
Sql :: mysql-split-and-join-the-values 
Sql :: sqlite headers 
Sql :: sql developer format sql 
Sql :: datagrip go to line 
Sql :: MQL4 mql4 run ea on all symbols by adding to just one chart 
Sql :: insert thai language sql server 
Sql :: update mysql from paypal shopping cart and ipn 
Sql :: mysql start of today 
Sql :: sql server in linux 
Sql :: how to find constraints on a table in oracle 
Sql :: mysql select all columns and specific fields as 
ADD CONTENT
Topic
Content
Source link
Name
6+3 =