When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By default you can see a failover cluster as a combination...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
05-08-2008
Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability
Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then ensure to test them by restoring on to the standby...
So what are your options in Server consolidation and not to harm the performance for the applications that are happily sitting across your data center and you have this mammoth task to consolidate the servers to save physical space etc. No doubt that Server Consolidation and avoiding performance loss...