locked
Backup RRS feed

  • Question

  • Hi,

    Please explain answer for the following question in simple way. so that i can understand tour answer.

    Q) if your database is 80 GB, we have 'D' and 'E' drives. In 'D' drive we have data files. now the customer asking for backup of 80 GB database. You have sufficient space in D AND E drive. Now how you will take backup of 80 GB database.? What are the steps..?


    Thanks And Regards, T.Anil Kumar. " Please "vote as helpfull if this post solves your problem ";

    Thursday, March 28, 2013 11:30 AM

Answers

  • Q) if your database is 80 GB, we have 'D' and 'E' drives. In 'D' drive we have data files. now the customer asking for backup of 80 GB database. You have sufficient space in D AND E drive. Now how you will take backup of 80 GB database.? What are the steps..?

    You can backup the database using a T-SQL backup command, SSMS GUI or maintenance plan.  After backing up the database, you will want to store a copy on a different server or removable media so that you can restore in the event of a disaster.  Keep in mind that there a many different restore scenarios, ranging from accidental deletion of a single row to loss of the entire data center.  Your recovery plan will need have contingencies to address all of these.

    The best location for a local backup is one that does not contain data or log files so that the local backup is readily available after either data or log storage is lost.  The secondary copy can be used if the drive with the local backup file is lost.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Thursday, March 28, 2013 12:31 PM
    Answerer

All replies

  • Thunga,

    Backup full contains the whole database! or all the 80GB, if you are using SQL Server 2008 enterprise you can try backup with compression, if not, there is nothing you can do.


    Fabrizzio A. Caputo
    MCT
    Certificações:
    Oracle OCA 11g
    MCITP SQL Server 2008 Implementation and Maintenance
    MCITP SQL Server 2008 Developer
    ITIL V3 Foundation
    Blog Pessoal: www.fabrizziocaputo.wordpress.com
    Twitter: @FabrizzioCaputo
    Email: fabrizzio.antoniaci@gmail.com

    Thursday, March 28, 2013 12:18 PM
  • Q) if your database is 80 GB, we have 'D' and 'E' drives. In 'D' drive we have data files. now the customer asking for backup of 80 GB database. You have sufficient space in D AND E drive. Now how you will take backup of 80 GB database.? What are the steps..?

    You can backup the database using a T-SQL backup command, SSMS GUI or maintenance plan.  After backing up the database, you will want to store a copy on a different server or removable media so that you can restore in the event of a disaster.  Keep in mind that there a many different restore scenarios, ranging from accidental deletion of a single row to loss of the entire data center.  Your recovery plan will need have contingencies to address all of these.

    The best location for a local backup is one that does not contain data or log files so that the local backup is readily available after either data or log storage is lost.  The secondary copy can be used if the drive with the local backup file is lost.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Thursday, March 28, 2013 12:31 PM
    Answerer