MSSQL – Find white/free space in database file and log files.
Replace master, with the name of you database
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
Replace master, with the name of you database
I need to search for entry in logfiles between 3/8-2017 and 6/8-2017. So i make this powershell script to prevent search all IIS logfiles. This script will copy all log files from the orginal...
USE [TestDb] GO ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([TestDb_Log], 1) ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT GO Where TestDB, is the database name, and TestDB_Log is the SQL Log file name.
1. Create a new directory called e:\vdilogging\. The Network and Local service accounts need to have write access to this folder. If you using vdisk in standard mode, remember to save it on locally...
Sidste kommentar