Restore issue

Discussion in 'Databases' started by MUVEKA, Feb 25, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,
    I am trying to restore my Database using the SQL Tools in my control panel.
    This is the error I am getting:


    Restore failed. Your database has been rolled back. The backup file is larger than your current alloted SQL database size.
    The .bak file that I am uploading is 42 MB against a DB size of 300MB. Any idea why I may be getting this error? Thanks to anyone who can help!
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    can't really tell just by the error message.


    i recommend you opena support ticket.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. Thanks for the reply. The good news is that the restore finally was successful.


    Here was the issue: The DB.bak file size was one sixth the size of storage I had for my DB on DASP account but the restore would fail continuously.So what I did was using SQL Server Management Studio Express, shrunk the Database and then later created the back up. Well, in the process the size for .bak file increased; however, the restore went through smoothly. This makes me think that even though the actual data sizein my databasewassmall (meaning the space occupied for the storage for actual data); SQL server may still be allocating a miminum space for each table. And so, when I tried to restore the DB, it exceeded the 300MB space I have on my DB at DASP account.


    But now my DB is up and running and connected to my ASP. NET application![​IMG]
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page