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

SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup

May 13, 2010

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Backup and Restore, SQL Index, SQL Scripts

Recently, I have observed that not many people have proper understanding of what is bookmark lookup or key lookup. Increasing numbers of the questions tells me that this is something that developers encounter every single day, but have no idea how to deal with. I have previously written three posts…

SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008

May 3, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Note: Please read the complete post before taking any actions. This blog post would discuss SHRINKFILE and TRUNCATE Log File. The script mentioned in the email received from reader contains the following questionable code: “Hi Pinal, If you could remember, I and my manager met you at TechEd in Bangalore.…

SQL SERVER – Attach mdf file without ldf file in Database

April 26, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Background Story: One of my friends recently called up and asked me if I had spare time to look at his database and give him a performance tuning advice. Because I had some free time to help him out, I said yes. I asked him to send me the details…

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

April 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage

Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source…

SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward

March 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages, SQL Scripts

I received the following email from one of my readers. Dear Pinal, I am new to SQL Server and our regular DBA is on vacation. Our production database had some problem and I have just restored full database backup to production server. When I try to apply log back I…

SQL SERVER – Backup master Database Interval – master Database Best Practices

August 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Backup and Restore

During a recent consultancy project, I was asked to review a Database Backup plan. While going through the plan, I noticed that there was no backup for the master database. When I questioned this, the DBA informed me that it was not necessary. I was startled and couldn’t resist explaining…

SQL SERVER – Four Different Ways to Find Recovery Model for Database

July 16, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Perhaps, the best thing about technical domain is that most of the things can be executed in more than one ways. It is always useful to know about the various methods of performing a single task. Today, we will observe four different ways to find out recovery model for any…