THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Restore   (RSS)
  • Restoreability and SSMS

    I have written about this before, how SSMS generates restore commands that will fail. This post is about showing what it might look like using screenshots. If you always use T-SQL directly to do restore, then you won't be affected by this. But if you expect to be able to perform restore using the restore dialog, then read on. The problemThe issue ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 16, 2016
  • Geek City: Point in Time Recovery for Operations on Memory—Optimized Tables

    In my class in Budapest last week, someone asked if point-in-time recovery was supported for transactions on memory-optimized tables.  I couldn’t think of a reason why not, but I had never tried it. And just because there is not a technical inhibitor to allow certain functionality, it is often the case with a new technology that certain ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 22, 2015
  • SQL Server Backup and Restore

    From Red-Gate web site you can download, for free, the eBook SQL Server Backup and Restore written by Shawn McGehee. One of the most important activities under DBA responsibility is to check backups and maintain an efficient recovery plan. In this book, Shawn McGehee explains how to build an efficient recovery plan; because after you have known ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on August 14, 2013
  • SQL Server v.Next (Denali) : Restoring a SQL Server 2000 database

    I guess the title should be, ''You can't restore a SQL Server 2000 database on Denali.''  I had the occasion just today to recover some data from a backup I took way back in 2008 (!) for a colleague who was still on 2000 at that time (again, !).  When I tried to restore the backup on my local Denali instance, I received this error ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 18, 2010
  • Connect Digest : 2010-02-06

    Upgrading a database with read-only filegroups Earlier today, I complained that I should be able to upgrade a database with read-only filegroups.  In this case an upgrade from, say, 2000 to 2005 is blocked because the engine can't update the system schema / structure.  Since I am trying to protect the data, not the system schema, I ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 6, 2010
  • When will my backup / restore / index reorganize finish?

    The DMVs are a great way to get a closer look at what is actually going on in your system.  In particular, for some operations, SQL Server populates the percent_complete and estimated_completion_time (in milliseconds) in the DMV sys.dm_exec_requests.  This can be very useful if you want to know how long your BACKUP or RESTORE will take ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 30, 2009
Privacy Statement