Free SQL Server Learning - Making the most out of SQL Server Agent
solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Tip Categories SQL Server Tutorials SQL Server Webcasts SQL Server Whitepapers SQL Server Tools SQL Server Questions and Answers MSSQLTips Authors About MSSQLTips SQL Server User Groups SQL Server Events I am MSSQLTips MSSQLTips Advertising Options

MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page




































SQL Product Highlight

Red Gate Software - SQL Developer Bundle

Improve database development with a bundle of 12 SQL developer tools from Red Gate. The SQL Developer Bundle will help you:

  • Improve testing and productivity. Find and fix errors caused by differences between databases with SQL Compare.
  • Troubleshoot errors. Browse a history of changes, find broken code or conflicts, and automatically generate scripts to resolve inconsistencies.
  • Simplify database deployments. Use one-click deployment across multiple servers.

Learn more!











Backup Tips

Administration
  Check for full SQL Server database backups before creating other backups
  CLR function to delete older backup and log files in SQL Server
  Do you know if your SQL Server database backups are successful
  Large log backups with bulk operations and read only databases
  SQL Server backup and restore of the Resource database
  SQL Server backup and restore to network drive
  SQL Server Backup Plan
  Using the FORFILES Command to Delete SQL Server Backups
  What is in your SQL Server backup files?
Configuration
  Changing the default SQL Server backup folder
  Function to Return Default SQL Server Backup Folder
  Purging MSDB Backup and Restore History from SQL Server
  SQL Server Database Backup Retention Periods
  Stop logging all successful backups in your SQL Server error logs
Copy Only
  Copy Only Backup for SQL Server 2005 and SQL Server 2008
  COPY_ONLY Backups with SQL Server 2005
Encryption
  Encrypting SQL Server backups with open source tools
Mirrored Backups
  Mirrored Database Backup Feature in SQL Server 2005 and SQL Server 2008
Monitoring
  How to find out how long a SQL Server backup took
  How to monitor backup and restore progress in SQL Server 2005 and 2008
  Script to find SQL Server databases without transaction log backups
  Script to retrieve SQL Server database backup history and no backups
  SQL Server Backup History Analysis
  SQL Server Database Backup and Restore Failure Notifications
  Verifying Backups with the RESTORE VERIFYONLY Statement
Performance
  Backup to multiple files for faster and smaller SQL Server files
  Options to Improve SQL Server Backup Performance
  Striping SQL Server Database Backups
Scheduling
  Standardize SQL Server backups and maintain existing job schedules
Scripts
  Automating Transaction Log Backups for All SQL Server Databases
  Backup and Restore SQL Server databases programmatically with SMO
  Differential Database Backups for SQL Server
  How to Identify and Backup the Latest SQL Server Database in a Series
  Simple script to backup all SQL Server databases
Security
  Encrypt and safeguard your SQL Server database backups
  Using passwords with SQL Server database backup files
SnapManager
  Comparing SQL Server Native Backup Times to SnapManager Backups
  Configuring Snap Backups with SMSQL for NetApps and SQL Server
  Considerations for Implementing SnapManager for SQL Server
Tools
  SQL Server 2005 Backup Product Options
Troubleshooting
  Issues with SQL Server backup log with no_log or truncate_only
Tutorials
  SQL Server Backup Tutorial

 

Sponsor Information
SQL Server having some performance issues? Idera SQL check. FREE SQL Server enhancement.

SQL Developer Bundle: Cut out dull work with 12 tools for simpler, faster database development. Free trial

What grade do you think your SQL Servers get? Find out with a SQL Server Health Check consultant in the USA.

Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now.

The SQL Server Security THREAT - It’s Closer Than You Think

Copyright (c) 2006-2013 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com