SQL Server 2005 - What will it not support?
I've been busy sticking my head deep into SQL Server 2005. What is missing?
- Backup compression (like Sybase) is still not available. Typically, most databases not containing BLOBs shrink from 1Gb down to 220Mb. The benefits are tremendous as there is less Disk I/O, resulting in better dump performance (CPU cycles are generally not in short supply so the additional overhead does not hurt), and the dump takes much less space on disk. You backup software then needs to drag a lot less over the network when it is writing to tape. Yes, there is commercial stuff out there, but when you manage 250 servers, you can not roll out their hotfixes every few weeks because of bugs. sqlwish@microsoft.com has heard about it already.
- Installations of SQL Server 7.0 will not be supported by SQL Server 2005 Management Studio. Not really an issue, but most people have been assuming that it will as SQL 2000 Enterprise Manager did.
Up to this point, that is about all.
I am busy with preparing a bunch of presentations for various conferences, and my demos area bit gutsy for Beta software. 4 Node clusters, with log shipping and database mirroring, in one. Of course, all running on Microsoft Virtual Server. Watch this Blog for when the presentations will show up near you.