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 |
|
marco gwiliani
Starting Member
25 Posts |
 Posted - 2008-04-02 : 15:18:09
|
| I am using MS SQL 2005 Express. I have a database with two filegroups, the PRIMARY default filegroup, and then filegroup X. I have a backup of the PRIMARY filegroup only, and am trying to restore it to my database. When I select the .bak file to restore from, I am NOT given any 'backup sets to restore' - I therefore cannot select the filegroup to restore it. Can anyone advise? (NOTE - I have backed up the transaction log on the database I am restoring to already)ThanksMArco |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 15:38:14
|
| Why you backedup only Primary FG? Choose restore from filegroup option and specify FG and transaction log as well. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 15:39:08
|
| Better to restore with different name for testing. |
|
|
|
marco gwiliani
Starting Member
25 Posts |
Posted - 2008-04-02 : 15:51:45
|
| I have a database, PRIMARY filegroup and empty, however I have some readonly data in filegroup X. I am restoring from a test database where I have populated the database (PRIMARY filegroup) with data. Now I am testing backing up and restoring the PRIMARY filegroup. Filegroup X is to big to backup each time which is why I created it, so I could segregate this data. I can specify the backup to restore from OK, however when I do that I have no backup sets to restore from? NOTE - I am using the GUI of ms sql 2005 ee and dont have the options you have specified. I am wondering if it is anything to do with the data being backed up on one server and restored on another - some kind of permissions issue perhaps?MArco |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 15:58:34
|
| Did you copy the .bak file to other server?Check this out:http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1259912,00.html |
|
|
|
marco gwiliani
Starting Member
25 Posts |
Posted - 2008-04-02 : 16:15:34
|
| Hello - Yes I did copy the .bak file from another server. Thanks for the link. Just so I understand, is what I am trying to do classified as a piecemeal restore...?and if so it looks like I may not be able to do it, as I am using 2005 Express, not enterprise, though why MSE would let me backup and then not restore seems strange.. |
|
|
|
|
|
|
|
|
Restoring a DB File to an existing DB