Category: Computer

0

mssql get the backup information with copy_only information.

I need to find a way to see if the backup chain where broken. On my search I found this could script, created by “hot2use”I have found this script on a forum.https://dba.stackexchange.com/questions/204883/how-to-tell-if-a-backup-log-chain-is-broken The script...

0

Move from Office 365 to Onpremise in a Hybrid enviroment

import-module msonline(install-module msonline) $O365CREDS = Get-Credential$ONPREMCREDS = Get-Credential #used UPN Username $SESSION = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $O365CREDS -Authentication Basic -AllowRedirection Import-PSSession $SESSIONConnect-MsolService -Credential $O365CREDS #You can run these commands, to check...

0

MSSQL How long will data be in cache/buffer

How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in the cache. Witch the...

0

MSSQL – See buffer hit ratio

Whit this code, you can see how much of query in percent at this moment is reading from the cache/buffer. Share this:

0

CAPI2 Error in event viewer when taking backup

When taking backup of a SQL server i got this error in my event viewer, every times the backup is running:Event Viewer Error: Cryptographic Services failed while processing the OnIdentity() call in the System...