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

SQL SERVER – 2008 – Introduction to Row Compression

July 6, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

In my previous article SQL SERVER – 2008 – Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I like when I get request about any subject to write about from my readers. Row…

SQL SERVER – 2008 – Introduction to New Feature of Backup Compression

July 3, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Backup and Data Storage is my most favorite subject and I have not written about this for some time. I was experimenting with new feature of SQL Server 2008 and I come across very interesting feature of Backup compression. Let us see example of Database AdventureWorks with and without compression.…

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake

May 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQL Backup and Restore, SQL Data Storage, SQL Scripts

It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been long time since I wrote something funny on this blog. Recently, I have came across forum discussion regarding backup misery of one of the developer. I…

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2

April 10, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Function, SQL Scripts

Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I tried to test it, it did not work for me. However, I have received email from two of my Jr. DBA who have done experiment about this and they are suggesting it works.…

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)

April 7, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage

Just received question from one of the DBA Question: I do not have full backup of my database. My .mdf and .ldf are corrupted. Is there any way I can restore database now? Answer: Sorry. I do not think there is any way you can do it. Try attaching this…

SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified

February 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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

Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://darkslategrey-bat-805937.hostingersite.com)

SQL SERVER – Mirrored Backup Introduction and Explanation

December 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

SQL Server 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take…