THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Restore   (RSS)
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement