none
SQL Backup

    Question

  • Dear DB Admin,

    We have SQL Server 2014 SP2 enterprise edition .. and we have SQL DB the DB name is Subash.mdf this DB we are using this DB more-than 10 years  it's working well there is no issues .. But I would like to take backup yearly based ... an example from 01-01-2014 to 31-12-2014 then 01-01-2015 to 21-12-2015 ... Is it possible ? if you say yes please let me know how can i do it 

    I am waiting for your valuable feedback 

    Thanks 

    Sunday, December 25, 2016 11:05 AM

Answers

  • you can take backup in job.job can schedule in yearly basis.

    yearly backup is difficult for  01-01-2014 to 31-12-2014 then 01-01-2015 to 21-12-2015.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    • Marked as answer by Suriya Subash Sunday, December 25, 2016 3:54 PM
    Sunday, December 25, 2016 11:31 AM
  • What do you mean with yearly based? Only backup data from a certain year?

    That is nothing you can do with the BACKUP command, as this command just backs up data pages with little knowledge of the data. If you want to extract data for a certain year, you would have to write a program that is specific for the application of the database and which adheres to the business rules. For instance, if your database has orders of some sort, you may also want to include the full customer and product register in the extract, although some customers and products may have been entered in earlier years.

    I hope that you take regular backups frequently, for instance every night, and you take log backups many times during the day.

    • Marked as answer by Suriya Subash Sunday, December 25, 2016 3:54 PM
    Sunday, December 25, 2016 12:43 PM
  • Hi Erland,

    Thanks for your message and ... Very simple boss i need certain year just single full backup  backup only

    An example 01-01-2015 to 31-12-2016 ( Full Backup )

    Thanks

    Subash

    • Marked as answer by Suriya Subash Sunday, December 25, 2016 3:54 PM
    Sunday, December 25, 2016 1:56 PM
  • Sorry, there simply is no such concept in SQL Server. You will need to roll your own.

    • Marked as answer by Suriya Subash Monday, December 26, 2016 5:46 AM
    Sunday, December 25, 2016 2:58 PM

All replies

  • you can take backup in job.job can schedule in yearly basis.

    yearly backup is difficult for  01-01-2014 to 31-12-2014 then 01-01-2015 to 21-12-2015.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    • Marked as answer by Suriya Subash Sunday, December 25, 2016 3:54 PM
    Sunday, December 25, 2016 11:31 AM
  • What do you mean with yearly based? Only backup data from a certain year?

    That is nothing you can do with the BACKUP command, as this command just backs up data pages with little knowledge of the data. If you want to extract data for a certain year, you would have to write a program that is specific for the application of the database and which adheres to the business rules. For instance, if your database has orders of some sort, you may also want to include the full customer and product register in the extract, although some customers and products may have been entered in earlier years.

    I hope that you take regular backups frequently, for instance every night, and you take log backups many times during the day.

    • Marked as answer by Suriya Subash Sunday, December 25, 2016 3:54 PM
    Sunday, December 25, 2016 12:43 PM
  • Hi Erland,

    Thanks for your message and ... Very simple boss i need certain year just single full backup  backup only

    An example 01-01-2015 to 31-12-2016 ( Full Backup )

    Thanks

    Subash

    • Marked as answer by Suriya Subash Sunday, December 25, 2016 3:54 PM
    Sunday, December 25, 2016 1:56 PM
  • Sorry, there simply is no such concept in SQL Server. You will need to roll your own.

    • Marked as answer by Suriya Subash Monday, December 26, 2016 5:46 AM
    Sunday, December 25, 2016 2:58 PM
  • Dear Erland,

    Please let we know is there any another idea .. Because i need old year backup an example 2015 just one backup is enough 

    Thanks 

    Monday, December 26, 2016 5:48 AM
  • So why don't you tell your full story from start to end? What do really you mean with "I need old year backup"? Why do you need this? What exact purpose does it fill? Is this what your boss has asked you to supply? Your client? Have you asked them in more detail what they are looking for?
    What sort of system is the database for? A home-written? A third-party application? Some other product like Sharepoint of Dynamics?

    In case you didn't get it, the way you have phrased the question so far, the answer is "no, you can't do that with backup, you need to write your own program". So it's useless to nag that question over and over.

    Monday, December 26, 2016 9:23 AM
  • Dear Erland,

    Thanks for your mail ..  old year backup for audit purpose we need to verify some table from old years DB so my IT manger asked me last year (2015) so is it possible to take any one of  full DB from last year ?

    Thanks

    Monday, December 26, 2016 12:35 PM
  • If you did not take a backup at 2015-12-31 when you were supposed to, you are screwed, sorry.

    How often is this database backup anyway?

    Monday, December 26, 2016 1:32 PM