﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged Backup and Recovery</title><link>http://www.sqlservercentral.com/</link><description>Content tagged Backup and Recovery posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Backup SQL Server Databases with a Windows PowerShell Script</title><description><![CDATA[In a previous tip on Backup and Restore SQL Server databases programmatically with SMO, you've seen how you can use Windows PowerShell to backup and restore SQL Server databases. In this tip, I will cover how to use Windows PowerShell to generate SQL Server backups]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68542/</guid><pubDate>2009/10/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68542/</link></item><item><title>Backups daily monitoring</title><description><![CDATA[This script finds the last run status for Full / TL backups.]]></description><guid>http://www.sqlservercentral.com/scripts/Backups+monitoring/68022/</guid><pubDate>2009/09/04</pubDate><link>http://www.sqlservercentral.com/scripts/Backups+monitoring/68022/</link></item><item><title>7 Ways To Crash a Database</title><description><![CDATA[Many articles on database administration take the perspective of trying to help you do your job better.  We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.  ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67880/</guid><pubDate>2009/08/27</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67880/</link></item><item><title>Validate SQL Server Backups Exist with Policy Based Management</title><description><![CDATA[I recently submitted a tip regarding the existence of your backup files using the undocumented system stored procedure xp_fileexist. But how would you go about executing that script against all your SQL Server 2005 and SQL Server 2008 instances?  I took that script and decided to go one step further using Policy Based Management to create a custom policy that you can then run against all your SQL Server 2005 and SQL Server 2008 instances.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67884/</guid><pubDate>2009/08/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67884/</link></item><item><title>Protection Close To Home</title><description><![CDATA[For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/67923/</guid><pubDate>2009/08/21</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/67923/</link></item><item><title>SQL Backup 6: Wind of Change</title><description><![CDATA[One could be forgiven for thinking that there's little more you can do with third-party backup software than just ...er... backup databases. Shawn McGehee gives us his personal take on the implications of the improvements that have been made to SQL Backup for version 6.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67894/</guid><pubDate>2009/08/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67894/</link></item><item><title>How SQL Server recovery models impact your SharePoint ...</title><description><![CDATA[SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model. But which model is right for your enterprise?<!-- NEW product just released! -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_v2_200909&utm_campaign=sqlolrnative"><img alt="SQL OLR Native" height="68" src="http://www.red-gate.com/images/sql_server_central/olr_native_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>New product just released! </strong><br />Recover individual database objects from native SQL Server<br> backups and restore them to any database. <a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_v2_200909&utm_campaign=sqlolrnative">Download a free trial </a><br>of Red Gate’s new SQL Object Level Recovery Native™.<img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67742/</guid><pubDate>2009/08/17</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67742/</link></item><item><title>Truncating the log</title><description><![CDATA[]]></description><guid>http://www.sqlservercentral.com/questions/Backup+and+Recovery/66631/</guid><pubDate>2009/08/05</pubDate><link>http://www.sqlservercentral.com/questions/Backup+and+Recovery/66631/</link></item><item><title>Script to check that backup files still exist for SQL Server</title><description><![CDATA[You have configured your database backup jobs without any problems. The backups themselves seem to be working, but are the files still where you think they are? How do you know they have not been moved, or worse, deleted to free up some space on your server? And when would you find out that the files were no longer there?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67646/</guid><pubDate>2009/08/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67646/</link></item><item><title>Copy Only Backup for SQL 2005 and SQL 2008</title><description><![CDATA[Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67334/</guid><pubDate>2009/06/30</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67334/</link></item><item><title>When is a Backup Considered Successful?</title><description><![CDATA[What makes a successful backup? New author Steven Bouffard talks about some things you might want to consider when evaluating if your backup process is considered a success.<!-- NEW product just released! -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_v2_200909&utm_campaign=sqlolrnative"><img alt="SQL OLR Native" height="68" src="http://www.red-gate.com/images/sql_server_central/olr_native_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>New product just released! </strong><br />Recover individual database objects from native SQL Server<br> backups and restore them to any database. <a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_v2_200909&utm_campaign=sqlolrnative">Download a free trial </a><br>of Red Gate’s new SQL Object Level Recovery Native™.<img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/articles/Backup+and+Recovery/66703/</guid><pubDate>2009/06/08</pubDate><link>http://www.sqlservercentral.com/articles/Backup+and+Recovery/66703/</link></item><item><title>How to find out how long a SQL Server backup took</title><description><![CDATA[Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66895/</guid><pubDate>2009/05/22</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66895/</link></item><item><title>Operating system Error 112</title><description><![CDATA[The error message pops up when you try to restore the database to a different server or to a desktop or to a FAT32 file system. Learn a couple of ways for dealing with this error.]]></description><guid>http://www.sqlservercentral.com/articles/Backup+and+Recovery/65685/</guid><pubDate>2009/04/17</pubDate><link>http://www.sqlservercentral.com/articles/Backup+and+Recovery/65685/</link></item><item><title>When was the last time your SQL Server database was restored</title><description><![CDATA[Often times we are asked the question &quot;when was the last time my database was restored, and where was it restored from?&quot;  In this tip, we will look at some of the system tables that capture restore history information and how you can query these system tables to answer this question.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66574/</guid><pubDate>2009/04/16</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66574/</link></item><item><title>Why Tape is Good</title><description><![CDATA[I write an editorial about why I thought tape still had a place in backups . There were some interesting responses that said disk works well for them and they wouldn’t go back to tape. I used to think the density was a big deal, along with cost, but maybe...<!-- NEW product just released! -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_v2_200909&utm_campaign=sqlolrnative"><img alt="SQL OLR Native" height="68" src="http://www.red-gate.com/images/sql_server_central/olr_native_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>New product just released! </strong><br />Recover individual database objects from native SQL Server<br> backups and restore them to any database. <a href="http://www.red-gate.com/products/SQL_OLR_Native/offers/try_olr_native.htm?utm_source=ssc&utm_medium=rss&utm_content=OlrNative_launch_v2_200909&utm_campaign=sqlolrnative">Download a free trial </a><br>of Red Gate’s new SQL Object Level Recovery Native™.<img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66457/</guid><pubDate>2009/04/08</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66457/</link></item><item><title>The Need for Tape</title><description><![CDATA[Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/66320/</guid><pubDate>2009/03/26</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/66320/</link></item><item><title>The Need for Tape</title><description><![CDATA[Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66354/</guid><pubDate>2009/03/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66354/</link></item><item><title>The Need for Tape</title><description><![CDATA[Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66352/</guid><pubDate>2009/03/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66352/</link></item><item><title>The Need for Tape</title><description><![CDATA[Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66351/</guid><pubDate>2009/03/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66351/</link></item><item><title>Creating Striped Backups - SQL School Video</title><description><![CDATA[This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.]]></description><guid>http://www.sqlservercentral.com/articles/Video/65295/</guid><pubDate>2009/03/19</pubDate><link>http://www.sqlservercentral.com/articles/Video/65295/</link></item><item><title>Full Transaction log</title><description><![CDATA[One of the common questions often asked online is how to respond to a full transaction log. New author Krishna Potlakayala brings us a few techniques for dealing with this.]]></description><guid>http://www.sqlservercentral.com/articles/Transaction+Log/65877/</guid><pubDate>2009/03/18</pubDate><link>http://www.sqlservercentral.com/articles/Transaction+Log/65877/</link></item><item><title>Downtime</title><description><![CDATA[One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/65974/</guid><pubDate>2009/03/13</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/65974/</link></item><item><title>Database Backup</title><description><![CDATA[]]></description><guid>http://www.sqlservercentral.com/questions/Backup+and+Recovery/65753/</guid><pubDate>2009/02/26</pubDate><link>http://www.sqlservercentral.com/questions/Backup+and+Recovery/65753/</link></item><item><title>Do You Verify Your Database Backups?</title><description><![CDATA[Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/65795/</guid><pubDate>2009/02/24</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/65795/</link></item><item><title>Do You Verify Your Database Backups?</title><description><![CDATA[Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66034/</guid><pubDate>2009/02/23</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66034/</link></item><item><title>Do You Verify Your Database Backups?</title><description><![CDATA[Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66033/</guid><pubDate>2009/02/23</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66033/</link></item><item><title>Downtime</title><description><![CDATA[One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/65974/</guid><pubDate>2009/03/13</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/65974/</link></item><item><title>Downtime</title><description><![CDATA[One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.<!-- Exceptional DBA -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup"><img alt="ExceptionalDBA" height="68" src="http://www.red-gate.com/images/marketing/SSC/EXDBA_V2_68px.gif" width="68" border=”0”/></a></td>
  <td><strong>Free “How to Become an Exceptional DBA (2nd ed.)” eBook</strong><br /><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_how_to_become_exceptional_dba.htm?utm_source=ssc&utm_medium=rss&utm_content=BackupAndBook200909&utm_campaign=sqlbackup">Download your copy</a> and a free trial of Red Gate SQL Backup for<br>
 robust SQL Server database backups.<br /><img src="/Images/spacer.gif?d=ad_bkup2" /></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/65979/</guid><pubDate>2009/02/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/65979/</link></item><item><title>Downtime</title><description><![CDATA[One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/65976/</guid><pubDate>2009/02/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/65976/</link></item><item><title>Downtime</title><description><![CDATA[One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/65975/</guid><pubDate>2009/02/19</pubDate><link>http://www.sqlservercentral.com/redirect/articles/65975/</link></item></channel></rss>