Browse by Tags

All Tags » sql server » restore (RSS)
SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?
Published 19 May 8 4:28 AM | SSQA.net
To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...
Filed under: , , , , , , ,
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: , , , , , , , , , ,
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: , , , , , , , ,
List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition
Published 16 November 7 5:14 PM | SSQA.net
The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...
Filed under: , , , , , , ,
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: , , , , , , , , , , , , ,
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: , , , , , ,
Error: Database diagram support objects cannot be installed because this database does not have a valid owner
Published 6 September 7 4:0 AM | SSQA.net
If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects...
Filed under: , , , , , , ,
Multiple transaction log backups or Single transaction log backup file, which is better?
Published 27 August 7 4:51 AM | SSQA.net
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...
Filed under: , , , , , ,
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: , , , ,
FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server
Published 27 June 7 11:42 AM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database...
Filed under: , , , , , ,
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: , , , , , ,
FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database
Published 5 June 7 6:39 PM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database http://support.microsoft...
Filed under: , ,
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: , , , ,
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: , , ,