Skip to content

Kenneth Dalbjerg

Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus

Kenneth Dalbjerg

Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus

  • Home
  • Curriculum Vitae
    • Home
    • sql
Andet

Veeam backup and Replication – Failed to call RPC function ‘Vss.TruncateSqlLogs’

admin December 19, 2022 0 Comments

Today i have this warning in my Veeam Backup and Replication backup job log, for an SQL server:Failed to finalize guest processing. Details: Failed to call RPC function 'Vss.TruncateSqlLogs': Error…

MSSQL

MSSQL Backup History Query

admin February 1, 2021 0 Comments

To see MSSQL history Query, run this SQL query. It will show all backups between the 1 january 2021 and 1 february 2021, order by Database and then Last backup…

MSSQL

SQL – Check with statements that are blocked

admin April 30, 2020 0 Comments

You can check which statements are blocked by running this

Andet

SQL Agent Job history – T SQL

admin November 13, 2019 0 Comments

Here are a Script, that you can use to extract the SQL Agent Job History This will also tell you the job steps Thanks to Chad Churchwell  - https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/

MSSQL

Implement SQL Server Agent Jobs with AlwaysOn Availability Groups

admin July 4, 2019 0 Comments

The function I use fn_hadr_group_is_primary from this post is a UDF (User Defined Function) that we create in the master database. The function gets an Availability Group name as an input parameter and returns…

Andet MSSQL

See if a database is using Enterprise features of an Microsoft SQL server.

admin November 21, 2018 0 Comments

Run this command to see if any database on the SQL Server is using enterprise features  

MSSQL

Downgrade an SQL Server from Enterprise to Standard – Disable compression

admin November 21, 2018 0 Comments

If you got an error about compression, when trying to attach the database from an enterprise version to a standard version. You will have to attach the database to an…

MSSQL

Shring SQL log file

admin May 5, 2015 0 Comments

USE GO ALTER DATABASE SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(, 1) ALTER DATABASE SET RECOVERY FULL WITH NO_WAIT GO   Where TestDB, is the database name, and TestDB_Log is the SQL Log file…

Citrix

Citrix XenApp failed to connect to Data Store

admin May 15, 2013 0 Comments

Today i have this problems on one of the Citrix XenApp servers, that the service IMA won't connect to the Data store. It failed with this events: 1. Citrix XenApp…

MSSQL

Change SQL Collation

admin March 23, 2012 0 Comments

Steps for chaning Collation: Take backup of Databases and logins. Detach all databases execpt system databases. (All users databases) Find the SQL server installation path (Root of the CD) Run…

Posts navigation

1 2

Next Page »

Kategori

  • Andet (36)
  • Computer (280)
    • Ahsay (7)
    • Certificate (3)
    • Cisco (7)
    • Dell (7)
    • ESXi (5)
    • Fortinet (1)
    • HPE (1)
    • Linux (54)
      • Debian (23)
      • Kubuntu (4)
      • Postfix (5)
    • Nimble Storage (1)
    • Programmering (11)
      • PHP (1)
    • vmware (2)
    • VPN (5)
    • Windows (190)
      • Active Directory (3)
      • AppV (1)
      • AzureAD (1)
      • CA (2)
      • Citrix (27)
      • Exchange (44)
      • GPO (1)
      • HyperV (3)
      • MSSQL (30)
      • Office365 (6)
      • Powershell (31)
      • RDS / Terminal (6)
    • Xenserver (14)
  • kennethdalbjerg.dk (13)
  • MIG (51)
  • Sjovt (4)

Links

  • Andersvn.dk – A colleague
  • Collision.dk – A colleague
  • Frijsendal Friskole
  • Gratis mailhotel
  • Guldhammer
  • Heidi Qvistgaard
  • Hestehus.dk
  • HTC Desire HD
  • IPCalc
  • It-afdelingen A/S Århus
  • Labrador Hvalpe
  • Lbjerg.dk – Link Index
  • Maria & Jens
  • Mobilt internet
  • Nyt tag Herning
  • SMTP
  • SMTP Server
  • Tjen Penge

Arkiv

Kalender

October 2023
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Jun    

Tag Cloud

Active Directory Ahsay Andet AppV AzureAD CA Certificate Cisco Citrix Computer Debian Dell ESXi Exchange Fortinet GPO HPE HyperV kennethdalbjerg.dk Kubuntu Linux MIG MSSQL Nimble Storage Office365 PHP Postfix Powershell Programmering RDS / Terminal Sjovt vmware VPN Windows Xenserver

cmu.edu

You Missed

Fortinet VPN

Problems with FortiClient and no traffic after succesful connection

PHP

Connect to 365 Exchange mailbox with IMAP and OAuth

MSSQL

Clear mssql cache

AzureAD Office365 Windows

Computer won’t join Azure AD

Kenneth Dalbjerg

Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus

Copyright © All rights reserved | Blogus by Themeansar.

  • Home
  • Curriculum Vitae