part of database backup

  • Hi,

    Is it possible to backup part of database.

    i have 2 yrs data in my database can i backup last yr data only??

    if possible

    whenever i want full database can i combine those 2 backup??

    how can i get full database??

  • i have 2 yrs data in my database can i backup last yr data only??

    if possible

    Not unless it's already in a specific file, I don't think: http://technet.microsoft.com/en-us/library/ms179316%28v=sql.105%29.aspx

    whenever i want full database can i combine those 2 backup??

    Which two backups? You would just carry out a full backup if you wanted to back up the full database.

    how can i get full database??

    It's not clear what you mean.

    Before you go any further you should try to read this book http://www.sqlservercentral.com/articles/books/89519/ (the e-book/pdf version is free of charge)

  • my question is can i take backup of half of the database means

    can i remove last yr data from my database and keep it as a backup??

  • You can back up the entire database and then delete the older data. You can't take a backup of part of a database unless the database has multiple files or filegroups and has been designed to allow partial backups to work effectively.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • This introduces the concept of the a partial backup. As everyone has already stated, you can only do this if you design the database and it's structure to support the concept.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • How can i Know whether my Database structure supports partial backups???

  • Did you read the link that Grant posted?

    John

  • refer below articles..

    https://www.simple-talk.com/sql/backup-and-recovery/partial-backup-and-restore/

    http://www.mssqltips.com/sqlservertutorial/27/sql-server-partial-backups/



    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • PravB4u (12/6/2013)


    http://www.mssqltips.com/sqlservertutorial/27/sql-server-partial-backups/

    That one is quite misleading and has no discussion of the considerations or requirements. I'd avoid it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply