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 :: reset sql primary key 
Sql :: sql developer format sql 
Sql :: sql update from another table join 
Sql :: psql check table fields 
Sql :: Call to undefined function mysql_query() in D:xampphtdocsimageindex.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com 
Sql :: sql select column name like from multiple tables 
Sql :: Shell Comands 
Sql :: sum over partition by postgresql 
Sql :: salesforce cpq apply immediately 
Sql :: sql query to find difference between total no. of rows and distinct rows in sql server 
Sql :: select concat alter table mysql 
Sql :: fast sql column count 
Sql :: SQL: find gap in sequence 
Sql :: export all stored procedures to .sql files 
Sql :: SELECT record from database 
Sql :: mysql server create connection string 
Sql :: sql queries questions 
Sql :: subquery in Delete 
Sql :: sql server interview questions 
Sql :: mysql select all columns and specific fields as 
Sql :: get month and year from date in mysql sequelize 
Sql :: can pandas fetch data from sql 
Sql :: mysql listing get a particu particular user firsdt 
Csharp :: unity scene load 
Csharp :: regions unity 
Csharp :: unity gameobject teleporting 
Csharp :: c# new thread 
Csharp :: unity how to set an objects postion x,y,z 
Csharp :: c# get unix timespan 
Csharp :: c# check if string is empty 
ADD CONTENT
Topic
Content
Source link
Name
3+1 =