Post reply

Can a .bkp be deleted after it's been restored?

  • July 28, 2011 at 5:28 pm

    #241477

    Greetz!

    I have some .bkp files that I brought over from another server and restored to a new 2008 enterprise db.

    Now that they are restored, and there are new mdf and ldf files in place, is it ok to delete the .bkp file that kicked it off? Is this done simply by deleting the file via the File System or is there a better way?

    Thanks!

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • July 29, 2011 at 12:51 pm

    #1361040

    There is no reason you can't delete a backup file after you have restored from it (unless you want to keep it for archive). It is not being used by the system in any way.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • July 29, 2011 at 2:56 pm

    #1361139

    Hi,

    Lite speed backup file has Extension .BKP, If you are doing any upgrade from 2000 or 2005 to 2008 then i suggest you to archive the backup file for some retention Period.

    If you want to delete the backup file and this is only for one time then you can just delete in regular way but if this is repeated activity, which you are doing often the you can create SQL jobs using command line to delete those backup files.

    I hope this helps you..

  • July 30, 2011 at 4:50 pm

    #1361268

    Yes that does help. These bkp files are part of a sharepoint upgrade so we won't be too many of them and not for long (hopefully).

    Thanks!

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

Viewing 4 posts - 1 through 3 (of 3 total)

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