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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2010-09-14 : 15:13:32
|
| Sir , I have one database in which we have 30 tables .20 are primary tables and 10 are Transaction tables .They have huge data year wise .Now i want to make two partition of my database year wise .one database have 2006 to 2009 year data & another databaes have 2010 to current date .Is there any way to do this .Please help me out Sir .Yaman |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-14 : 15:26:23
|
| have a look here http://msdn.microsoft.com/en-us/library/ms187802.aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-16 : 12:44:45
|
quote:
Originally posted by yaman
Sir , I have one database in which we have 30 tables .20 are primary tables and 10 are Transaction tables .They have huge data year wise .Now i want to make two partition of my database year wise .one database have 2006 to 2009 year data & another databaes have 2010 to current date .Is there any way to do this .Please help me out Sir .Yaman
seehttp://searchsqlserver.techtarget.com/tip/Table-partitioning-with-SQL-Server-2005------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Need Partition of Database