Microsoft Sql Server Tutorials: Importance of RAID in Databases. RAID is a disk system that contains multiple disk drives, called an array, to provide greater performance, fault tolerance, storage capacity, at a moderate cost. While configuring your server system, you typically have to make a choice between hardware RAID and software RAID for the server’s internal disk drives RAID systems are widely used as storage solutions to get the best I/O performance, depending whether the application is write intensive or read intensive. DBA RayRankins mentions in his book that for database-related applications, in order to minimize disk head movement and maximize I/O performance, it’s a good practice to spread random I/O’s (data changes) and sequential I/O’s (for the transaction log) across different disk subsystems.
I agree and endorse his view, as SQL Server, or for that matter any other database, is very much an I/O intensive system. Note: RAID is not a replacement for backups. Backups are very essential for any system. Did you like this post? Sauvegarde et restauration de bases de données dans SQL Server. 1.1 La sauvegarde d'une base de données - Après la connexion, affichez l'arborescence en cliquant sur le nom du serveur souhaité. - Cliquez sur Base de données puis sélectionnez la base de donnée souhaité. Il en existe deux sortes, la base de donnée utilisateur, visible dans cette arborescence ou une base de donnée système, pour cela, cliquez sur Base de données systèmes. - Clic droit sur la base de donnée / Tâches / Sauvegarder - Une fenêtre nommée "Sauvegarder la base de données" s'affiche, vérifiez le nom de la base de données. - Sélectionnez "Complète" dans le champ "Type de sauvegarde" - Vous avez accès à certaines options dans "Jeu de sauvegarde", vous pouvez modifier le nom, entrer une description correspondantes à la sauvegarde, ajouter une date d'expiration à cette sauvegarde (en cliquant sur "Après").
L'onglet "Options" offre la possibilité d'écraser la sauvegarde précédente si elle existe, d'en créer une différente, de vérifier la sauvegarde en fin d'opération... Validez. Sauvegarde et restauration de bases de données dans SQL Server. The SQL Server backup - foundation of any Disaster / Recovery. The SQL Server backup – foundation of any Disaster / Recovery by Ted Krueger (onpnt) on June 8, 2010 in category Database Administration Database Programming Microsoft SQL Server Microsoft SQL Server Admin. Article views: 6,921 Instapaper Welcome to our second class for HA and DR week of SQL University. Yesterday we went through defining HA and DR along with some common practices you can use. Today we are going to focus on the concept, “Backups are for sissies!” When all else fails and the walls are falling down on the database servers, backups will be your life preserver.
Define a backup A full database backup contains a full representation of the database with enough of the transaction log in order to recover everything when a restore is performed. Full Backup – Defined above as a full representation of the entire database and enough of the log to recover the point in which the backup was executed Last Resort Recovery They are not runThey are in the same site as the disaster Social Sitings.
Introduction. Welcome to SQLBackupRestore.com, your online resource for SQL Server backup and recovery issues. The articles are generally applicable to both SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL 2012. If any parts are applicable only to a specific version, they will be clearly indicated. The SQL Server Books Online documentation should still be your primary source of information on SQL Server. The information presented here is more of a troubleshooting guide, a discussion of common issues faced by users, when dealing with SQL Server backup and recovery issues.
If there are any topics you would like me to add, or suggestions on improving the articles, please drop me a line at yeoh.ray.mond@yohz.com. Conventions When a reference is made to a topic in the Books Online documentation, they are highlighted in bold blue, and the version of SQL Server they apply to is also stated. Code fragments are highlighted this way: Output from SQL Server are highlighted this way: Setting up log shipping using Management Studio. SQL Server 2005 SP2 was used to set up log shipping in this example.