Posts Tagged ‘DBCC Shrinkfile’
Script – Generate DBCC ShrinkFile for each datbase files
Posted by: JShah on November 6, 2009
Shrink the log to as small a size as possible (truncateonly)
Posted by: JShah on September 24, 2009
Database Articles
Knowledge based articles for the SQL Server, MySQL and Oracle
Widget
- DBCC TRACEON / DBCC TRACEOFF/ DBCC TRACESTATUS
- Login failed for user ’sa’ because the account is currently locked out. The system administrator can unlock it.
- google ads
- Index Rebuild vs Index Reorganize. Diffrence beweent Index Rebuild and Index Reorganize
- How to check SQL Services status from management studio?
- Join me on SQLPass.Org
- Service Principle Name
- Script to Verify the litespeed backup file
- Script to list out important properties of database
- Script to change the database compatibility level
Comments
 | JShah on DBA Roles and Responsibil… |
| JShah on Certification/Awards |
 | scvinodkumar on Certification/Awards |
 | vamsi on DBA Roles and Responsibil… |
 | sumudu on DBA Roles and Responsibil… |
