SQLGardner

Lisa Gardner - SQL Sever Premier FIeld Engineer

September, 2011

  • SQLGardner

    Implementing Log Shipping for Many Databases

    • 1 Comments
    In my previous post, I discussed using log shipping as a method for migrating databases to reduce application downtime. Using Management Studio to configure log shipping for each database is fine… until you have a large number of databases to implement. Here I will describe some sample scripts that will utilize a reference table and implement log shipping for multiple databases. I am sure there are other solutions that may fit your environment/situation better than this one, but I have had...
  • SQLGardner

    Minimizing DB Migration Downtime Using Log Shipping

    • 0 Comments
    A common and often unpleasant task for DBA involves moving databases between physically separate SQL instances. This could be due to a data center move, hardware refresh, SQL Server version upgrade, server onsolidation, company merger, and more. Whether you have a small number of large databases or a large number of small databases, this task can be quite tedious and time consuming. To complicate matters, DBAs are getting pressed more and more to reduce downtime affecting their applications. What...
  • SQLGardner

    Backup Compression Confusion

    • 0 Comments
    "When I use backup compression, I notice the backup file is very large but then once the backup is complete the file is much smaller. Is this how it is supposed to work?" In the past few weeks I have seen this question pop up a number of times, so I thought I would write a short note about it. Short answer..... YES. This is done as the backup file is initially preallocated to a certain percentage of the db size. This is a performance enhancement to keep from having to grow the file over...
  • SQLGardner

    Introduction

    • 0 Comments
    I am a SQL Server Premier Field Engineer who has been with Microsoft since March, 2011. Before joining Microsoft, I worked as a DBA for over 13 years. My primary technical expertise is with SQL Server (starting with version 6.0), but I have also managed DB2, Sybase, and Oracle systems. Most of the systems I have supported have been large scale OLTP applications in the financial services industry. Within SQL Server, I have gained many years of experience with HA/DR solutions (clustering, mirroring...
Page 1 of 1 (4 items)