Browse by Tags

Backup and Restore of Analysis Services Database - gotchas

Published 12 December 7 3:38 AM | SSQA.net

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...

Filed under: sql server, restore, high availability, backup, olap, dimension, cube, rolap, molap, holap, storage mode

Improving Backup and Recovery RTO RPO in a SAN - think on your SQL Server environment

Published 6 December 7 12:47 PM | SSQA.net

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...

Filed under: sql server, restore, high availability, backup, disk, recovery, san, best practice, hardware

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

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...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

How to find whether backup is performed using SQL native methods or third party tools?

Published 23 October 7 4:59 AM | SSQA.net

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...

Filed under: sql server, restore, high availability, backup, dba, best practices, third party

Database Mirroring: FQDNs are Your Friends!

Published 16 June 7 2:29 PM | SSQA.net

Cross posted from : Adam Machanic SQLBlog that helped me to resolve one issue during a DB mIrroring issue. Read More...

Filed under: high availability, backup, blog, fqdn, database mirroring

Business Continuity White Paper

Published 9 May 7 12:42 PM | SqlServer-QA.net (SSQA)

Related content on the Business Continuity: Link to download and you might need to register with the originator Read More...

Filed under: business continuity, high availability, backup

Recover a corrupt database with backup and restore stragegy

Published 6 May 7 4:56 AM | SqlServer-QA.net (SSQA)

http://sqlserver-qa.net/blogs/tools/archive/2007/05/06/recover-the-corupt-databases-with-the-features-in-backup-restore-sql-server-2005.aspx Read More...

Filed under: sql server, restore, high availability, backup

Recover the corupt databases with the features in backup & restore - SQL Server 2005

Published 6 May 7 4:50 AM | SqlServer-QA.net (SSQA)

Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL...

Filed under: sql server, msdn, microsoft, high availability, backup, blogs