Microsoft - PowerCram Blog

Microsoft SSL Diagnostics

A common problem for administrators of IIS servers is configuring and troubleshooting SSL enabled websites. To assist in administrators efforts, Microsoft has designed a tool – SSL Diagnostics – to aid in quickly identifying configuration problems in the IIS metabase, certificates, or certificate stores. This tool allows users to review configuration information in a easy to read view […]

MS SQL Backup Database to Disk

To create a full database backup using Transact-SQL Execute the BACKUP DATABASE statement to create the full database backup, specifying: The name of the database to back up. The backup device where the full database backup is written. Example BACKUP DATABASE AdventureWorks TO DISK = ‘C:BackupsAdventureWorks.BAK’

Shrink (truncate) Microsoft SQL transaction log files

Shrink (truncate / purge) MS SQL transaction log files. Use <dbname>Goalter database <dbname> set recovery simplegodbcc shrinkfile (<dbname>_log, 100)gocheckpointgodbcc shrinkfile (<dbname>_log, 100)alter database <dbname> set recovery fullgo Example: Use myDatabaseGoalter database myDatabase set recovery simplegodbcc shrinkfile (myDatabase_log, 100)gocheckpointgodbcc shrinkfile (myDatabase_log, 100)alter database myDatabase set recovery fullgo