March 13, 2006 at 10:46 am
Here's what I'd like to do: I have a big database (DatabaseA) that exists on 1 drive, with the log on another drive. I'd like to restore DatabaseA's backup, but call it DatabaseB so I can retrieve some data from B and copy it to A. I don't have room on any one drive for the whole Database, so I thought I should be able to create DatabaseB, spread across multiple drives, and restore DatabaseA to B and have it use the files on the various drives. I created DatabaseB the way I want it, but can't seem to get the restore to work.
ie.... In the original database 'A', I just have 1 LDF and 1 MDF. That's what the .BAK is created from. I want to restore it do a database 'B' with 1 LDF, and 1 MDF and 5 NDFs.
Is this doable ?
March 13, 2006 at 1:25 pm
Not possible. The restore allows you to specify the placement of each file, but you cannot split a file to multiple locations.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply