Find out how to query the log space usage for all DBs on the server with a single statement. This is a quick way Continue reading “Find Log Space Used”
Tag: File issues
Find File Lock
Have you ever been plagued by a file you couldn’t delete or move because it was being held open by something else? Well here Continue reading “Find File Lock”
Cycle Error Log on all Servers using Powershell
Here I show you how to use the Carrier Method for using powershell to cycle all your error logs. This is an excellent way Continue reading “Cycle Error Log on all Servers using Powershell”
Fix AutoShrink in Powershell
Here I show you how to turn off AutoShrink on a DB and then how to make sure it’s turned off on all your DBs.
Loading Files without SSIS
Loading Files without SSIS.
Replace Text in File
Here I show you how to replace a given string in a file and either write it back to the same file, or write the Continue reading “Replace Text in File”
Troubleshoot Missing DB File
Come with me on a quick trip to see how to troubleshoot a missing database file.
BCP out
Learn how to BCP data out of a table.
Moving DB Files
Moving database files is easy, but misunderstood. Here I’ll show you how to move user DB files using 2 methods.
Hack-attak a damaged DB
What do you do if you have a set of data and log files you can’t attach because the log is damaged? Here I show Continue reading “Hack-attak a damaged DB”