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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Partitioning

Author  Topic 

iqbalbutt
Starting Member

1 Post

Posted - 2015-03-01 : 22:54:28
When you load the data into a new partition table, can it to done online without any downtime? because I have few tables that are around 250 gigs and more.


TT

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-02 : 04:06:58
best thing:

1. create a table with same schema, indexes etc.
2. load new data into that table
3. switch this table into the big partitioned table.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2015-03-02 : 13:17:00
https://technet.microsoft.com/en-us/library/ms191160(v=sql.105).aspx



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -