Restore seems to have stopped?

[croydon]

I have been trying to use the SQL Server 2005 Restore function to install a copy of a database on to my PC. The .bak file is 29MB and when the Restore started, it quite quickly reached 50%.

The dat and log files appear to have been built as they have stopped growing, but the function has remained at 50% for the last two hours.

Has anybody else seen this problem?

 

[SQLBill]

Do you have access to the original database? How much free space did the database have in the data and log files? A restore has to 'claim' that free space in addition to the space actually used by data. Maybe you ran out of space.

-SQLBill

Posting advice: FAQ481-4875

 

[croydon]

I actually needed the database in order to work from home. My PC has 7GB free. I will check on the size of the original database tomorrow.

 

[SQLBill]

When you use Enterprise Manager, right click on the database. In the right pane, you will see two bars showing the size of the data and the log files. That is the size of the files and will include empty space that is allocated to the file. SQL Server backs up that space also.

You can also run sp_spaceused on the database and it will show you how much space the files are taking up.

-SQLBill

Posting advice: FAQ481-4875

 

[croydon]

SQLBill, I checked the database size and that was not a problem. I also tried the Restore on another PC and received a similar message.

Instead I created a Backup Device and made a Back Up to this, then copied the Backup file to the PC. I then ran the Restore. For some reason (I don't understand why) this worked and I now have a copy of the database on my PC.

Thanks for your help.