Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Richardrt
Starting Member
1 Post |
 Posted - 2007-09-23 : 14:09:23
|
| I am new to sql server 2005. I backed up our database from SQL 2000 and tried to restore it to Sql server 2005.everytime I try to create a new database or restore I get an insuffcient disk space message. I have over 250 gigabytes of free storage and the database I am trying to restore is only 200 megabytes. I shrank the the database as well and they backed it up and tried to restore. Still the same problem. Is there a setting somewhere that I neglected to set when I installed SQL Server 2005?I would really be grateful for any help.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-23 : 17:14:22
|
| Run 'restore filelistonly' to see how much disk space needed to restore the db. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Problems creating and backing up
Perhaps try doing the Restore in T-SQL, rather than the GUI tools, so you have more control over what is happening?See: