Forum Discussion

tahaay's avatar
tahaay
Copper Contributor
Jun 17, 2024

.BAK file restore in SSMS

hi, All. I am trying to restore database using .Bak file in (using ssms). But When I am restoring it shows me error of memory. I have attach the pic below. Even my C drive have 132 gb free space. What should I do in this ? Please help

 

 

 

 

  • LainRobertson's avatar
    LainRobertson
    Silver Contributor
    Jun 17, 2024

    tahaay 

     

    You need 304.8 GB of space. Whether you add that to your C: or another space, that's the absolute minimum required to complete the restore. The 132 GB free space you mentioned simply doesn't come anywhere near the required 304.8 GB.

     

    Keep in mind that this free space is on the computer running SQL Server, which may or may not be your client.

     

    If you can't find that amount of free space, you can't perform the restore.

     

    Cheers,

    Lain

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jun 18, 2024

     

    What should I do in this ? Please help

    tahaay , the error message is more then clear: You need more free disk space.

    And it's not the best idea to locate a database (file) on system drive C: If it runs out-of-space you are going to harm your complete system.

    And a new drive to the machine.

Resources