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

SQL SERVER – Standby Servers and Types of Standby Servers

July 11, 2009

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…

SQL SERVER – Find Current Location of Data and Log File of All the Database

February 17, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL System Table

As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in SQL Server data installation folder – the place where I have all the .mdf and .ldf files are stored. I often go to that folder and clean up all unnecessary…

SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup

February 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Backup and Restore, SQL Data Storage, SQL Server Security, SQL Utility

The most interesting thing about writing blog at SQLAuthority.com is follow up question. Just a day before I wrote article about SQL SERVER – Restore Master Database – An Easy Solution, right following it, I received email from user requesting reason for importance of backing up master database. Master database…

SQL SERVER – Restore Master Database – An Easy Solution

February 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL Utility

Today we will go over two step easy method to restore ‘master’ database. It is really unusal to have need of restoring the master database. In very rare situation this need should arises. It is important to have full backup of master database, without full backup file of master database…