Taking Differential BackUps from the Last Full BackUps

Posted on 2009-04-16
Last Modified: 2013-11-07
I need to take differential backups for SQL SERVER 2005 Database..
i m using the code the .NET 2.0 FX and VB.NET
hence, when i click a button i m calling the Stored Procedure as it runs the differential backups for the particular Database....

MY Question is here ?

First i have taken full backup for the database ex: 200 MB [size of the full backup]
and then after i run differential backup for the same database.
but i dont understand that without knowing when the database full backup is taken or without specifying the last taken full back up file on what basis the differential backup works in sqlserver...

give me any idea on this ??

TO DISK = 'c:\test\testdb.bak'


Open in new window

Question by:KumaraPrathipati
    1 Comment
    LVL 6

    Accepted Solution

    Not sure what exactly you are asking but in short:
    All backups are recorded in the msdb database so simply a database knows when and what kind of backup was taken of it. You can use the information in the backup views to see when the last full backup of a database was and what differential and or transactional backups where taken.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now