Pages

▼
Showing posts with label Backup/Restore. Show all posts
Showing posts with label Backup/Restore. Show all posts
Wednesday, 17 January 2024

Looking deeper into the physical & logical architecture - Transaction Log File

›
Beyond all doubt, it is essential to have a good understanding of the Transaction Log (T-Log) so that we can diagnose unforeseen performance...
Sunday, 17 December 2023

Getting Important Information of SQL Server Backups

›
Regardless of the method employed to take SQL Server backups, they must be carefully monitored around the clock, particularly in critical da...
Friday, 12 January 2018

MSSQL_ENG003165: An error was encountered while replication was being restored/removed. The database has been left offline

›
While restoring a replicated database without KEEP_REPLICATION  option, SQL Server will remove replication settings by executing  sp_restore...
Friday, 13 October 2017

Purging old backup files by using forfiles windows tool

›
It is well know that most backup strategies include a step to purge backup files to keep the most recent backups in the database server so t...
Friday, 19 August 2016

Why is the .txt history detail file of SQL Backup Job not created?

›
Clearly, we always need to have some kind of history for SQL Backup jobs in order to check whether or not they were executed correctly. I pe...
Monday, 8 February 2016

Using KEEP_CDC option to keep CDC metadata

›
Having a database with Change Data Capture (CDC) enabled, we will need to take this recommendation into consideration during the restore pro...
Monday, 18 October 2010

SQL11 (Denali): How to migrate SQL Server 2000 databases to SQL Server 2012?

›
Having found 'SQL Server 2000 (80)' inside the compatibility levels supported by SQL Server 2012, I need to say that the upcoming ve...