SQL Backup and Restore « SQL Server Journey with SQL Authority

Archive for the ‘SQL Backup and Restore’ Category

SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup

Posted in PostADay, Readers Question, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 28, 2011 | 7 Comments »

I recently received following question from reader. I would like to share the complete story in few short sentences with you to give you complete idea. Let us call the reader Margie. Our long email conversation is converted into chat like conversation Margie: Hi Pinal – I am seeing strange behavior with regards to my [...]

Read Full Post »

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012

Posted in PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Function, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 27, 2011 | 8 Comments »

Recently I was going over few advanced options of SQL Server 2012 in database properties and I found a new option in the property screen. Properties screen of SQL Server 2008 R2 Properties screen of SQL Server 2012 I got little curious and decided to learn what does this new feature indicates. When I started [...]

Read Full Post »

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on December 23, 2011 | 12 Comments »

Blogging is like writing a big novel in parts. It has its own mood and it has its own colors. Someday I feel like writing philosophy and some day I like writing theory and some day just a script. Today is one of the day when I just feel like providing working script for user [...]

Read Full Post »

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Error Messages, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on December 17, 2011 | 7 Comments »

I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘D:\Backup\SQLAuthority.bak’. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level 16, State 1, Line 1 [...]

Read Full Post »

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

Posted in PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology on October 3, 2011 | 14 Comments »

Scroll down at the end of this post to win my SQL Wait Stats Book. I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When I install SQLBackupAndFTP and configure [...]

Read Full Post »

Older Posts »