How to Shrink SQL Server 2012 Transaction log file
use eSPTest;
go
alter database eSPTest set recovery simple;
go
dbcc shrinkfile(eSPTest_log,200)
go
alter database eSPTest set recovery full;
go
Subscribe to:
Post Comments (Atom)
How to Change Instance Type & Security Group of EC2 in AWS By David Taylor Updated April 29, 2023 EC2 stands for Elastic Compute Cloud...
-
Alert: After SAN Firmware Upgrade, ASM Diskgroups ( Using ASMLIB) Cannot Be Mounted Due To ORA-15085: ASM disk "" has inconsiste...
-
Installing QLogic drivers on CentOS Linux hosts I have a couple of hosts in my lab with QLA2342 HBAs, and use the drivers from QLogic ins...
-
7 Important CellCLI Commands for Exadata DBA Now you are an Exadata DBA and I suppose you know Exadata basic Components and Feature...
No comments:
Post a Comment