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…
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…
You can check which statements are blocked by running this
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/
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…
Run this command to see if any database on the SQL Server is using enterprise features
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…
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…
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…
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…
admin