none
Database Backu up and shrinking process RRS feed

  • Question

  • What is standar method for taking schedule back up

    What is standard method for Shrinking Database

    Monday, September 16, 2019 6:14 PM

Answers

  • What is standar method for taking schedule back up

    http://ola.hallengren.com

    What is standard method for Shrinking Database

    Standard is to not do it. This is an exceptional task.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Monday, September 16, 2019 9:27 PM
    Moderator
  • Hi Kaushalya Medocal Foundation,

     

    >>What is standar method for taking schedule back up

     

    You can use sql agent job to perform scheduled backup. Please refer to https://www.sqlshack.com/multiple-methods-for-scheduling-a-sql-server-backup-automatically/

     

    >>What is standard method for Shrinking Database

     

    Please refer to: Shrink a Database . But you should consider shrinking only when the following conditions are met:

    You desperately need the space and can’t add disk space to the system

    You deleted a lot of data (or grew the data file too much) and you don’t expect the data files to grow back. A good example would be to shrink files which are on a filegroup that will become read-only, such as with date-based partitions.

    This is a manual operation and the shrink is not part of a recurrent maintenance task

    You first tried SHRINKFILE with the TRUNCATEONLY argument. The operation won’t induce fragmentation and the SHRINKFILE will be very fast.

     

    You can only perform file modification operations once. So you cannot perform database backup and database shrinkage at the same time.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, September 17, 2019 7:12 AM

All replies

  • You can use SQL Agent Jobs for these purposes.
    Monday, September 16, 2019 6:59 PM
  • What is standar method for taking schedule back up

    http://ola.hallengren.com

    What is standard method for Shrinking Database

    Standard is to not do it. This is an exceptional task.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Monday, September 16, 2019 9:27 PM
    Moderator
  • Hi Kaushalya Medocal Foundation,

     

    >>What is standar method for taking schedule back up

     

    You can use sql agent job to perform scheduled backup. Please refer to https://www.sqlshack.com/multiple-methods-for-scheduling-a-sql-server-backup-automatically/

     

    >>What is standard method for Shrinking Database

     

    Please refer to: Shrink a Database . But you should consider shrinking only when the following conditions are met:

    You desperately need the space and can’t add disk space to the system

    You deleted a lot of data (or grew the data file too much) and you don’t expect the data files to grow back. A good example would be to shrink files which are on a filegroup that will become read-only, such as with date-based partitions.

    This is a manual operation and the shrink is not part of a recurrent maintenance task

    You first tried SHRINKFILE with the TRUNCATEONLY argument. The operation won’t induce fragmentation and the SHRINKFILE will be very fast.

     

    You can only perform file modification operations once. So you cannot perform database backup and database shrinkage at the same time.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, September 17, 2019 7:12 AM