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 |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2012-11-09 : 11:55:54
|
| Hi there,My client provides a shared SQL environment which rules as each instance can only support 30 Gb data and they can provide 2 instances for one database. I have a database which could grow up to 50 Gb in next year. My question is can I use these 2 instances next year when the data grows to 50 Gb? If yes, how? Or share me some links for guides. Thanks in advance. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-09 : 12:51:37
|
| You would have to shard your data accross multiple DBs. It is not something that is easily done out of the box, but it is possible. Windows Azure SQL DB makes it much easier I understand.-Chad |
 |
|
|
|
|
|
instance and disk space