Yes, i have filegroup for each month. I was forgot to modify the scheme to point next range to filegroup so by default it went to Primary.

Here is...

The actual data will be 350 GB for that month.. I am not only spliting the range, i need to also move the data from primary group to another filegroup....

Elliott, is there any other alternate route than what you told. I thought of doing those table transfers too but it just i have over 100 tables and it will...

Chuck,

I have seen those articles already before posting here. It won't help me since it's not addressing what i am looking for.

Thanks,

Jay

Yest the table counts will be same. Simple dump from one server to another server

Thank you everyone !!!!!!!!!

Thanks for all responses. Last thing, does anyone know any good online resource to prepare for those exams?

i have been working as SQL DBA for 3 years (2000/20005). I just want to get hands on resources that can prepare me for the certification.

it's running on Windows server 2003 with SP1. The server is SQL 2005 Enterprise Edison.  I am replicating the database to SQL 2000 and it's transcation replication. I deleted one...

try this code .... it will insert rows from table1 to table2 if doesn't exist.

insert into table2

select * from table1

where not exists

(select * from table2 where table2.eid...