<div>
Hi,<br />
<br />
I think the below article will give you clear idea of Diff. Backup and restore.<br />
<br />
Hope this will help you.<br />
<br />
<a href="http://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/" rel="ugc">http://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/</a>
</div>


Hi,

I think the below article will give you clear idea of Diff. Backup and restore.

Hope this will help you.

http://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/ [http://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/]

<div>
I saw that but that's an self backup. I was wondering about backups using backup exec. Do most people go full or diff/increm?
</div>


I saw that but that's an self backup. I was wondering about backups using backup exec. Do most people go full or diff/increm?

<div>
<div class="content wysiwyg-content">
Currently when backing up our 3 SQL server database nightly we run full backups. The total size is 820 GB for all the database servers. While the speed of the backup isn't an issue the amount of space it starts taking up is since we need to save at least 1 month of backups. I like to use either incremential or differential backups in backup exec but do not know how reliable incrementials or differentials are are when it comes to a restoring a DB.<br />
<br />
Any advice on whether diff or Incremental is the way to go for nightly backups. We can still do the full on the weekend.
</div>
</div>


Currently when backing up our 3 SQL server database nightly we run full backups. The total size is 820 GB for all the database servers. While the speed of the backup isn't an issue the amount of space it starts taking up is since we need to save at least 1 month of backups. I like to use either incremential or differential backups in backup exec but do not know how reliable incrementials or differentials are are when it comes to a restoring a DB.

Any advice on whether diff or Incremental is the way to go for nightly backups. We can still do the full on the weekend.

SQL server 2008 R2 backups using Backup exec

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A server is a computer program or a machine that waits for requests from other machines or software (clients) and responds to them. This architecture is called the client–server model. The clients may run on the same computer or may connect to the server over a network. The purpose of a server is to share data or hardware and software resources among clients. Typical computing servers are database servers, file servers, mail servers, print servers, web servers, game servers, and application servers.

Server Software

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.