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 |
|
idioteque
Starting Member
2 Posts |
 Posted - 2007-11-21 : 00:20:23
|
| Very new to the world of databases. Our current database situation is a train wreck, but I'm not at the point I can fix it. So, all I'm trying to do right now is copy our 'live' database so that we can use the copy for development, without worrying about blowing things up.Anyhow, the problem I have is that when I backup, and then try to restore the 'live' database, I'm told the drive doesn't have enough space, which is accurate (only has 1gig, needs 3gigs). FYI, EVERYTHING that has to do with our databases is currently on a 14gb partition, of which 13gigs are being used. There is an empty partition of 120gb just sitting there.Can somebody tell me what is the best way to get this 3gb development database up? I tried to route the Data and Transaction Log paths to the empty partition, but it still seemed to want to mess with the 14gb partition and told me there isn't enough space when I tried to restore. |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2007-11-21 : 01:12:48
|
| Hi,When u create the new Dev database specify 120gb partition name for the Data and log files,then restore the database. |
 |
|
|
idioteque
Starting Member
2 Posts |
Posted - 2007-11-21 : 04:42:59
|
quote:
Originally posted by PeterNeo
Hi,When u create the new Dev database specify 120gb partition name for the Data and log files,then restore the database.
Thanks for the response. :)Unfortunately, I did do that originally and it still seemed to have a problem with the smaller partition being close to full for some reason. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-21 : 15:02:05
|
| How did you restore db? What was the error message? Did you try move db files to another location during restore? |
|
|
|
|
|
|
|
|
No space to 'replicate' database