Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

restore file/filegroup for partitioned tables

 
   Database Help (Home) -> Data Warehouse RSS
Next:  Design Question Again.  
Author Message
awi kteern

External


Since: Apr 18, 2008
Posts: 4



(Msg. 1) Posted: Fri Apr 18, 2008 2:53 pm
Post subject: restore file/filegroup for partitioned tables
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

Hi.
Our DB has Primary file group (data and log files are there) where all
lookup are.

has 2 big tables each on own partition (by date) with their indexes.

so

Primary has file xxx_data.mdf and xxx_log.ldf

the 1 big table1 and its indexes are on paritions by year.
data of 1970 on part_1970 filegroup part_1970 filename part_1970.mdf
data of 1971 on part_1971 .......................same
thing.......................mdf
..up to 2008
..
..

and so the other table2 (but by 10 years)
data of the 70s on part_70s.mdf
data of the 80s on part_80s.mdf
..up to 2008
..
..
there are no FKs between tables ..


Now.
I need a way to get:
primary file group and its data
the last 2 partition of table1 (2007 and 2008)
the last 1 partition of table2 (2000s)

I did a backup for the file/filegroup
WITH NOFORMAT, INIT, NAME = N'Forecast-Full Filegroup Backup', SKIP,
NOUNLOAD, STATS = 10


when restoring (with move, REPLACE , NORECOVERY / RECOVERY )
I am getting that the DB is taken offline because something was not
completed.
and the DB shows as (restoring)..
what am I missing here.

THANKS

 >> Stay informed about: restore file/filegroup for partitioned tables 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How many fact tables allowed per cube? - Can an OLAP cube contain more than one fact table?

Dim table being recoginized as Fact Tables - I'm using AS 2005, I'm trying to create a cube using the wizard and AS 2005 is detecting my Dimension tables as being fact tables and when I try to switch them to Dim table, it will not let me go further. Does anyone know how to get through this? These..

Storing natural keys in the dimension tables, to aid ETL m.. - I'm a beginner at DW and BI. I'm posting to this NG because my current (and first) data warehouse project is using SQL Server 2005 and my question is regarding the Kimball book "The Microsoft Data Warehouse Toolkit" (2006). The authors are say...

how to import an xml file to sql - I am using 2005 Enterprise and Standard. I need to know to to import an xml file to both of these. Thank you Dee

SQL Scheduled Jobs - Is there a way to monitor schedule jobs and restart the jobs automatically when it faills and if it fails then notify the responsible person, is there a tool to do this ?
   Database Help (Home) -> Data Warehouse All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]