Re: sql server2005 for a change in 3TB range

Its not that it is impossible, but if I was going to do it I would firstly have GOLD support with MS, because when things go wrong you might just wish you had it.
You need a very well architected application, that is written to handle the idiosyncrasies of SQL Server locking, or you will constantly have issues with it. There is a new feature called read consistent snapshot that I would recommend, that should alleviate it somewhat. You will need to provide a fair amount of TLC if this is a frequently changing database to keep it running optimal, rebuilding indexes, amongst other tasks. You may not be able to run maintenance tasks during normal hours due to their impact on the system. You will want quality backup tools for the restores, quick efficient and reliable.

If this is to use for a DW with all the above caveats you should be ok, for a transactional DB I am not sure I would want to go there

Cheers

Peter

On Thu, 2007-11-08 at 10:50 +0000, hrishy wrote:

> Hi
>
> I know this is a oracle mailing lists but just wanted
> opinion from folks here if your environments hosts any
> Terrabyte DB on Sqlserver 2005.
>
> regards
> Hrishy

>
>

--
http://www.freelists.org/webpage/oracle-l