VIMP * backup

  • We have a custumerDB and its properties are

    size:14399.06 MB

    space available:4652.36 MB

    customerdb.mdf : 4.59 GB;

    customerdb.ldf : 9.46 GB;

    I took backup of the customterDB(using Litespeed) and the .bak file size is 15.6MB..

    and I tried to restore the customerDb from this .bak on the different server and everything is fine..

    BUT,My question is WHY my .bak size is 15.6 MB?

    -----------------------------------------

    Its a totally different question,doesnt related to above question.

    2)How can I un-install the hot fix installed on sql 2005?

    Any help is really appreciated ..

    Thanks

  • This is a duplicate post. See http://www.sqlservercentral.com/Forums/Topic638614-357-1.aspx

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • kiransuram19 (1/16/2009)


    We have a custumerDB and its properties are

    size:14399.06 MB

    space available:4652.36 MB

    customerdb.mdf : 4.59 GB;

    customerdb.ldf : 9.46 GB;

    I took backup of the customterDB(using Litespeed) and the .bak file size is 15.6MB..

    and I tried to restore the customerDb from this .bak on the different server and everything is fine..

    BUT,My question is WHY my .bak size is 15.6 MB?

    -----------------------------------------

    Its a totally different question,doesnt related to above question.

    2)How can I un-install the hot fix installed on sql 2005?

    Any help is really appreciated ..

    Thanks

    .bak file has less size than mdf obvious ..

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

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

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