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 |
|
chetanb3
Yak Posting Veteran
52 Posts |
 Posted - 2008-10-09 : 09:09:14
|
| Hi all,I have a problem wile restoring my database backup.Backupfile is 20GB.but i have only 6GB space on my windows drive.can i split the data file to more drive, can i provide any such option while restoring the database...?I even don't know how many datafile the backup contain ..Please help. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-09 : 09:20:17
|
| You should have done it while backup. Spread files across different drive and copy it across drive and restore all together.But 6GB is too less. You should increase you space. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-09 : 11:11:14
|
| Can you give some details about any other drives you have (size etc) and is the backup file on same drive as datafiles? If you have access to another drive or even a remote drive on a server you can move the backup file to this location (and so free space) and then restore from backup from new location.The last time I did this was on SQL Server 2000 where wizard did not allow restore from remote drive but you can do it directly in SQL assuming you set up mapping and permissions etc to remote drive. |
|
|
|
chetanb3
Yak Posting Veteran
52 Posts |
Posted - 2008-10-21 : 06:03:00
|
| i have restored backup using move option available with RESTORE DATABASE command.. |
|
|
|
|
|
|
Restore database problem