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

Backup & Restore practices - what you need to take care?

Published 16 July 7 8:13 AM | SSQA.net

What if I told you to take your latest production backup, restore it on a different machine and try using the database? Are you comfortable with that task? Do you think it will work? When was the last time you tested your backups? Denis Gobo has listed...

Filed under: sql server, restore, backup, best practice, production

Get backup and restore performance stats with a DMV

Published 12 June 7 8:25 AM | SSQA.net

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included...

Filed under: sql server, stats, performance, restore, backup, dmv, read

Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: "Restore failed for Server '<ServerName>' (Microsoft.SqlServer.Smo)"

Published 4 June 7 7:28 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the...

Filed under: sql server, restore, backup, ssms, database

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