SQL Data Storage Archives - Page 5 of 10 - SQL Authority with Pinal Dave

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

July 16, 2009

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…

SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY

July 15, 2009

Pinal Dave

SQL Tips and Tricks

SQL Backup, SQL Data Storage, SQL Restore, SQL Scripts, SQL Server

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 – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage

July 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage

When it comes to storing images in database there are two common methods. I had previously blogged about the same subject on my visit to Toronto. With SQL Server 2008, we have a new method of FILESTREAM storage. However, the answer on when to use FILESTREAM and when to use…

SQL SERVER – Standby Servers and Types of Standby Servers

July 11, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage

Standby servers – Standby Server is a type of server that can be brought online in a situation when Primary Server goes offline and application needs continuous (high) availability of the server. There is always a need to set up a mechanism where data and objects from primary server are…

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

April 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Data Storage, SQL Error Messages

This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from people who are frequenting using forums or have blog related to storage and…

SQL SERVER – Mirrored Backup and Restore and Split File Backup

April 5, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Introduction 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…

SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP

April 2, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Data Storage, SQL Utility

It goes without saying that Database Backup is the most important task for any Database Administrator (DBA). Naturally, large organizations always have a team of DBAs who execute Database Backup tasks. No matter how big or small an organization is, the importance of database backup remains the same across the…