SQL Backup and Restore Archives - Page 4 of 19 - SQL Authority with Pinal Dave

SQL SERVER – ReadOnly Databases with ReadOnly File Attribute

March 6, 2015

As part of continued series of ReadOny databases, the earlier blog had an interesting comment that read as some people were getting errors of 5120 and others. This got me curious and was in the pending list of solutions in some way. One of the readers had mailed me saying,…

SQL SERVER – Database Stuck in “In Recovery” Mode After Restart

March 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Read this blog and I am sure it will bring some instances in your environments. This is one of the common issues I have observed while working with SQL Server from long time now. In this blog we will discuss little details about the issue and possible action you might…

SQL SERVER – Finding Top Offenders in SQL Server 2012 – Notes from the Field #068

February 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Azure, SQL Backup and Restore

[Note from Pinal]: This is a 68th episode of Notes from the Fields series. Performance tuning gets easier with SQL Server 2012. For the first time, you can capture a workload and find your top offenders inside of Management Studio without having to write a single line of T-SQL or…

SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067

February 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…

SQL SERVER – The Basics of the SSIS Script Task – Notes from the Field #065

January 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSIS

SQL SERVER – How to Know Backup History of Current Database?

January 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Some blog post and scripts are like ever green references. One such blog has been Get Database Backup History for a Single Database. A number of you have pinged me and for amendments to that script with various ideas. Since that post was written more than 4+ years now, I…

SQL SERVER – Can Database Primary File Have Any Other Extention Than MDF

December 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Here is interesting question I received yesterday. I personally think it is one of the most interesting questions I have received this month. “Can Database Primary File Have Any Other Extention Than MDF?” Before you read the answer – think for a moment. Now read the answer in the next…