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 |
|
mike_a
Starting Member
1 Post |
 Posted - 2007-02-02 : 06:09:47
|
| Hi,I need to restore a db sent to me on DVD, restore filelistonly shows the log file to be 180gb and I don't have a drive here large enough to restore it to. I realise I can get the sending company to resize the log and do another backup but unfortunately time and geographical restraints are a problem. Is there any way to do a partial restore of the database file only? I've looked at partial restore using the primary filelist but it doesn't want to restore to a database that is not the same as the original, by that I mean they both have the same tables etc., but have come from different sources.Any help or pointers much appreciatedThanksMike |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-02 : 13:01:12
|
| Dunno whether it would help enough, but it might be worth trying to get RESTORE to create the database in a Compressed folder. Perhaps if the Log was empty when the backup was taken it might be "all zeros" of somesuch that compresses well.Then you can shrink it and then uncompress the folder. It will run like a dog (if at all!) in a compressed folder.Kristen |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-02 : 13:24:36
|
| A partial restore in SQL Server means restoring certain filegroups not just the data files.Tara Kizer |
|
|
|
|
|
|
Restore of data only possible?