Browse Blog Posts by Tags

All Tags » restore (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Context Menu Fix: Save and Restore Icon layout [Quick-Tip]

Tired of seeing your icons constantly re-arranged ? Every time you swap between screen resolutions, or turn on (or off) your dual monitor, you will most probably experience that you have to re-arrange your desktop icons. Many of the applications for dual...

Posted to Minty White by on Thu, Sep 23 2010
Filed under: Filed under: Icon Packs, Windows XP Customization, Windows Vista Customization, Windows 7 Customization, Customization, restore, menu, save, layout, layout.dll, context, icon, position, add
Restoring Full-text Catalog in SQL Server 2005 removes SQLServer2005MSFTEUser ACL

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Standard Edition & Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New Restoring...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Sep 21 2010
Filed under: Filed under: sql server, restore, users, kba, enterprise, fulltext, catalog
SQL Server FILESTREAM feature and Differential Backups

This post tries to explain the behavior of differential backups on a FILESTREAM enabled database. A number of times, I see questions looking for a confirmation whether Differential Backups will correctly backup the NTFS (FILESTREAM) files and restore...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Aug 4 2010
Filed under: Filed under: restore, backup, dba, tsql, filestream, sqlserver, #FILESTREAM, #DBA
SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

BACKUPS are key to recover the data during the disaster recovery, but many times just taking backups is not sufficient as you need to ensure the backups are good enough with no corruption. The subject line message though classified as an information message...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 19 2010
Filed under: Filed under: sql server, restore, dbcc, checkdb, best practices, backups, checksum, veirify only, database consistency
Competition! 10 licenses of Driver magician 3.5 [Worth $29.95]

Did you read about Driver Magician v.3.5 the other day ? Driver Magician offers a professional solution for device drivers backup, restoration, update and removal in Windows operating system. I am very pleased to announce that Michael Lee, developer of...

Posted to Minty White by on Mon, Jun 7 2010
Filed under: Filed under: free, Announcements, Competitions, Fun, restore, competition, Backup, win, unknown device, device driver, upgrade, missing driver
SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, May 23 2009
Filed under: Filed under: sql server, restore, tech-ed, mvp, error, BOL, best practices, backups, corrupted, system databases, resource databases
My top Enterprise Only features in SQL Server 2008

I think some users may not like it when certain features are mentioned as they are available in Enterprise Edition aka 'Enterprise Only'! It is not so easy to provide the great features with a minimal or free cost for any product, hence the licensing...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 7 2009
Filed under: Filed under: sql server, memory, restore, ssis, web, data mining, developer, standard, feature, fuzzy, cpu, licensing, change data capture, enterprise edition, online index, cost
Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 29 2008
Filed under: Filed under: sql server, restore, database, dba, backups, task, new features, scripting
SQL Server data and log files initialization, think multiple files, backup & restore performance!

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jul 25 2008
Filed under: Filed under: sql server, performance, restore, best practices, multiple, filegroup, backups, disks, throughput, files, tapes
SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?

To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 19 2008
Filed under: Filed under: sql server, restore, best practices, system, uninstall, windows 2003, cumulative update, downgrade
Backup and Restore of Analysis Services Database - gotchas

Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Dec 12 2007
Filed under: Filed under: sql server, restore, high availability, backup, olap, dimension, cube, rolap, molap, holap, storage mode
Improving Backup and Recovery RTO RPO in a SAN - think on your SQL Server environment

Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Dec 6 2007
Filed under: Filed under: sql server, restore, high availability, backup, disk, recovery, san, best practice, hardware
List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 16 2007
Filed under: Filed under: sql server, restore, database, kba, service pack2, x64, backups, modified
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 16 2007
Filed under: Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
How to find whether backup is performed using SQL native methods or third party tools?

Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 23 2007
Filed under: Filed under: sql server, restore, high availability, backup, dba, best practices, third party
Error: Database diagram support objects cannot be installed because this database does not have a valid owner

If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Sep 6 2007
Filed under: Filed under: sql server, restore, security, database, upgrade, error, diagram, authorization
Multiple transaction log backups or Single transaction log backup file, which is better?

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 27 2007
Filed under: Filed under: sql server, performance, restore, transaction log, multiple, log shipping, single
Backup & Restore practices - what you need to take care?

What if I told you to take your latest production backup, restore it on a different machine and try using the database? Are you comfortable with that task? Do you think it will work? When was the last time you tested your backups? Denis Gobo has listed...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 16 2007
Filed under: Filed under: sql server, restore, backup, best practice, production
FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jun 27 2007
Filed under: Filed under: sql server, restore, database, kba, access, checkpoint, denied
Get backup and restore performance stats with a DMV

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jun 12 2007
Filed under: Filed under: sql server, stats, performance, restore, backup, dmv, read

Page 1 of 2 (25 items) 1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.