Here is the quick script I use find last backup time for all the database in my server instance.
SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database
I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. Let us learn about Retrieve and Explore Database Backup without Restoring Database.
SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup
I recently got following email from one of the readers. It is about Backup Log file.
SQL SERVER – Find Location of Data File Using T-SQL
While preparing for the training course of Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning, I needed to find out where my database files are stored on my hard drive. It is when following script came in handy to find the location of the data file using T-SQL.Â
SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction
Introduction – Mirrored Backup
This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore.
Conventional Backup and Restore
Spilt File Backup and Restore
Mirror File Backup
Understanding FORMAT Clause
Miscellaneous details about Backup and Restore
SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY
I maintain a spreadsheet of questions sent by users and from that I single out a topic to write and share my knowledge and opinion. Unless and until I find an issue appealing, I do not prefer to write about it, till the issue crosses the threshold. Today the question that crossed the threshold is – what is the difference between NORECOVERY and RECOVERY when restoring database and what is the restore sequence.
SQL SERVER – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
I assume you all know that there are three types of Database Backup Models, so we will not discuss on this commonly known topic today. In fact, we will just talk about how to restore database that is in full recovery model. Let us learn about backup timeline.