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)
-
7 Important CellCLI Commands for Exadata DBA Now you are an Exadata DBA and I suppose you know Exadata basic Components and Feature... -
Alert: After SAN Firmware Upgrade, ASM Diskgroups ( Using ASMLIB) Cannot Be Mounted Due To ORA-15085: ASM disk "" has inconsiste...
-
7 Steps to Data Warehousing Data warehousing is a business analyst's dream—all the information about the organization's activitie...
No comments:
Post a Comment