Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure. The same methods/process has been completely...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-12-2007
Filed under: sql server, restore, high availability, backup, olap, dimension, cube, rolap, molap, holap, storage mode
Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the costs of restoring lost data. This web seminar will...
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-16-2007
Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to take care of data which is a prime task for every...
http://sqlserver-qa.net/blogs/tools/archive/2007/05/06/recover-the-corupt-databases-with-the-features-in-backup-restore-sql-server-2005.aspx