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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-11 : 16:37:43
|
| kevin writes "Hi, Simple problem really. I want to copy a database from a customer site to my own machine. The problem is that the database size at the customer site is many gigabytes, even though only 170 MB are being used. I have made a database backup at the customer server - this is 170 MB.When I try to restore from my 170MB backup file at my destination server, it tells sme that I dont have enough disk space - it wants to create a database many gigabytes in size, most of which will be empty.Is there a workaround for this...i.e. is the backup file that I now have any good to me without having a great big disk?If I do need to go back to the customer site, what should I do next time? - Kevin" |
|
|
|
|
|
how to restore a large database on a machine with less space