This article will help us identify the backup which was used to restore the database. This may seem simple when the database backup is from the same server but the complications begin when the backup is not from the same server.
2014-02-27
4,381 reads
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,530 reads
SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation?
2013-12-09
3,325 reads
This article describes the SQL Server database restore principles for full backups, differential backups and transaction log backups and how to perform the restores to get to a particular point in time. This tip describes SQL Server database restore principles on a database that is using the FULL recovery model.
2013-11-05
5,308 reads
2013-08-08
5,587 reads
2013-06-26
2,549 reads
2013-04-18 (first published: 2013-04-05)
1,462 reads
The most critical task for all DBAs is to have a Backup and Recovery strategy that ensures, every day, that in the event of a disaster they can restore and recover any database, within acceptable limits for data loss and downtime. Even with all the required backups in place, it's easy to miss subtle failings in the overall plan that can, and eventually will, defeat your recovery plans.
2013-01-28
2,889 reads
Developing a backup procedure that makes sure you can do restores should be one of your top priorities as a DBA. In this article Greg Larsen discusses some of the concepts to consider when developing, building and testing a backup strategy.
2013-01-14
3,298 reads
During presentations about doing database backups and restores, there seem to be two two types of questions that are commonly asked, Those that come from the floor during the presentation, and those that are asked in private afterwards. These are sometimes more interesting, and challenging to answer well.
2012-12-11
3,466 reads
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Comments posted to this topic are about the item You Have Homework
Hello all, I am having one heck of a time installing Microsoft Connector for...
hi, a peer of mine would like to be self sufficient in bringing small...
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers