Backup and Restore

Automating SFTP Downloads using WinScp Free Tool

Today's article is about how to Automating SFTP Downloads using WinScp Free Tool: This will be helpfull in many situations…

11 years ago

When do we use SQL Server Database in Restricted User Mode?

Why do we need restricted user SQL server? When performing some maintenance tasks, particularly in recovery situations, it is essential…

12 years ago

Why Copy-Only Backups taken in SQL Server?

A copy-only backup in SQL Server(any version like 2012 or 2008 or 2005) is taken in cases you do not…

12 years ago

SQL Server RPO and RTO

Recovery Point Objective(RPO) describes a point in time that data can be restored from. For instance, if there is data…

12 years ago

Different Restore options in SQL Server 2008

Different Restore options in SQL Server 2008: 1. Restore can be done for an entire database from a full database…

12 years ago

Different Backup options in SQL Server 2008

Different Backup options in SQL Server 2008: 1. Backup’s can be taken for a complete database, or one or more…

12 years ago

SQL Server 2008 BACKUP LOG WITH TRUNCATE_ONLY

BACKUP LOG WITH TRUNCATE_ONLY is no longer a recognized BACKUP option. This command get rid of the contents of your…

12 years ago

SQL Server 2008 Recovery Models and Transaction log usage

SQL Server 2008 Recovery Models In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and…

12 years ago

This website uses cookies.