Tag: "backup"
New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available
Jun 4th
Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »
New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available
Sep 10th
Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »
Ressourcendatenbank
Aug 2nd
Frage: Wer sichert eigentlich seine Ressourcendatenbank?
Anwort: Das sollte eigentlich jeder machen. Zwar nicht unbedingt täglich, aber zumindest nach jedem Upgrade oder Hotfix.
… mehr »
A little bit more information on multi location backups
Jan 26th
On of the advantages of backing up to multiple locations is that the data is read on the SQL Server just once, this is an advantage because the IO on the database files is kept to a minimum (in comparison on doing two backups one after the other). Then… more »
Backup to multiple locations at the same time (multiple copies of the backup files)
Jan 25th
Sometimes it can be usefull to have two ore more copies of the same backup (e.g. you have two locations/disks and want a copy in/on both)
So lets explain how to backup to two locations at once. First the bad news this is an Enterprise (SQL Server… more »
Backup, Integrity Check and Index Optimization - CTP
Dec 6th
Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization (Best Free Tool - Gold)scripts, a solution based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.
He makes some inte… more »
Pro SQL Server Disaster Recovery
Sep 1st
Datenbank-Server können (und werden) ebenso ausfallen wie alle anderen elektronischen Geräte. Von daher ist es grob fahrlässig, sich mit diesen Gedanken nicht rechtzeitig zu beschäftigen. Wie der daraus resultierende Plan aussieht hängt vom jeweiligen… mehr »
DBSave SQL Server Backup von DD-MEDSOFT
Aug 20th
DBSave SQL Server Backup
DBSave von DD-MEDSOFT ist eine auf dem NET Framework basierende BACKUP-Lösung zur Sicherung und Wiederherstellung von bis zu 4 Microsoft SQL Server Instanzen. Es werden alle MS SQL Server Versionen unterstützt -… mehr »
Backup, Integrity Check and Index Optimization
Aug 18th
Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-)
He made some important updates to his maintenance scripts:
Support for selection of schemas, objects and… more »
Backup, Integrity Check and Index Optimization
Jun 10th
Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-)
He made some updates to the maintenance scripts:
Changed behaviour in the job that deletes old output… more »
Rebuilding system databases in 2008 R2
Jun 4th
http://sqlblog.com/blogs/tibor_karaszi/archive/2010/06/03/rebuilding-system-databases-in-2008-r2.aspx more »
SQL Server Disaster Recovery: Recovering from Disasters Using Backups - Part II
Nov 6th
Paul S. Randal explains in his second feature article - TechNet Magazine November 2009 - the using of the RESTORE command.
Content:
The four phase of restore
What do you need
What are you able to restore
Excample restore scenarios
Considerations when… more »
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
Aug 25th
I'm sure, that's exactly what Albert Einstein meant in his quote:"Try not to become a man of success but rather to become a man of value", Ola Hallengren becomes a man of value - with his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity… more »
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
Jun 22nd
Ola Hallengren, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts:
Support for printing of commands without executing them. Set the new parameter… more »
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
Apr 20th
Ola Hallengren Ola, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts:
Support for Xml indexes
Support for Spatial indexes
Support for indexed views… more »
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
Mär 9th
Ola Hallengren hat eine neue Version seines frei verfügbaren Skripts für Maintenance, Integritätschecks und Index Wartung online gebracht.
Weitere Informationen und Download: http://ola.hallengren.com mehr »
Sichern und Wiederherstellen von Datenbanken
Feb 13th
Zielgruppe Dieser Artikel wendet sich an Einsteiger in das Thema Backup und Recovery beim SQLServer. Behandelt werden hier die Grundlagen in einfachen Szenarien. Alle weitergehenden Informationen sind in der Online-Hilfe zu finden, wo auch verschiedene… mehr »
Jobs on production instances
Jul 1st
A wonderful handout for SQL Server Jobs by Tara Kizer.
CU
tosc more »
SQL Server 2005 - Backup, Integrity Check and Index Optimization
May 9th
http://ola.hallengren.com more »
Did you track the growth of your database-backup?
May 7th
Frequently you'll want to know how fast your database-backup has been growing. Perhaps you have implement a SAN Backup-Device for Backup-to-disk, or you only want know how fast your database has been growing.This TSQL statement will query the… more »
Tuning the Performance of Backup Compression in SQL Server 2008
Apr 24th
There is an interesting technical note by using the backup compression and its benefits in SQL-Server 2008 at SQLCAT.
Follow up: http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
CU… more »
Was passiert mit noch nicht beendeten Transaktionen beim Backup?
Okt 16th
Transaktionen, die noch nicht beendet wurden, bevor der Backup Vorgang endet, werden ins Backup aufgenommen und später beim Restore zurückgerollt. mehr »
LogShipping Überblick
Sep 7th
Ziel dieses Artikels ist einen Überblick über LogShipping zu geben und die Grundzüge der Einrichtung und des Betriebs zu skizzieren. mehr »
Log Datei verkleinern ohne Backup zu machen
Jul 12th
Im Bezug auf das Transaktionsprotokoll des SQL Servers scheint es eine ziemliche Unsicherheit bei den meisten Anwendern zu geben. Dabei ist dies bei weitem kein Mysterium! mehr »
