[Previous] How to recover a damaged hard disk?...

 [Next] How do you get a database into recovery mode. in SQL Server...

Some related posts from Technorati and Google.

[SQLServerCentral.com Articles] Configuring SQL Server 2005 Failover Settings in Windows Server ...: For example, if the master database resides on cluster share H drive, then we have to make sure SQL Service has a dependency on H drive, such that SQL Service will wait for H drive being online before trying to bring itself online. Otherwise we will see error message if H drive is still in the process of bringing online when the SQL service resource is trying to start up.

[中国- 简体中文] SQL Server: Top Tips for SQL Server Clustering: it's also useful if you have to apply a service pack or hotfix to your principal, in which case you can manually failover to your mirror. While applying the service pack or hotfix, the old principal server is temporarily offline and the committed transactions occurring at the new principal are queued up, waiting to be sent back to the new mirror (old principal).

[SQLServerCentral.com Articles] Business Continuity for SQL Servers With a Standby Approach ...: SQL Server backup information is automatically stored in a system database called msdb on the same SQL Server Instance as where the backups are being performed.This is very handy when trying to perform recovery operations of existing databases as all the backups that have been taken appear in the Native Restore screen.Unfortunately, if entries in the msdb table are purged due to size constraints on the database or if the mdsb table is somehow corrupted, native recovery operations become a lot more troublesome for Point in Time Recovery. Point in Time recovery would allow not only complete backup files to be used for restores, but also the more frequently taken Differentials and Transactionals.Users would have to either write scripts or manually select each file and restore them in the proper order, especially in the case of Transactionals, so as to preserve database integrity.Furthermore, restoring databases from one SQL Server Instance to another SQL Server Instance becomes problematic because the local msdb database will not have backup information available to restore the database from.

[WMUG] [MS KBs] New KB Articles At Microsoft 30 Dec 2009 - Weekly Summary ...: 973785 FIX: Membership is not scripted in the predefined database roles after you script a database and enable the "Script object-level permissions" option in SQL Server 2005. 976565 FIX: A query that opens a cursor in an .

[TechNet Blogs] SMS&MOM : OpsMgr 2007: How to install and configure an RMS on a ...: To instantiate the RMS cluster group as a cluster, type the following, where G is the disk resource that is allocated to the cluster group that is being used to create this virtual Root Management Server and where <VirtualServerNetbiosName> is the network name resource allocated to the same cluster group:

[SQL Home rss feed] Database High-Availability: Soup to Nuts: By using a command-line version of SQL Data Compare, it is possible to keep databases in synchronisation in order to maintain a 'Warm Standby'. However, it is effective only for small databases, puts loading on the server, and synchronisation can be delayed by up to ten minutes, depending on how often the synchronisation takes place.

[SQLServerCentral.com Articles] Upgrade Strategies for SQL Server 2008 - SQLServerCentral: We should create a plan to recover from each phase and step of the upgrade process to help minimize data loss and reduce the time that data might be unavailable. This recovery plan might involve backing up a set of files, creating scripts to move database connections from the upgraded instance back to the original instance, or anything else we feel is necessary to get the old database instance back up and meet business uptime needs while you fix the upgrade problems.

[SQL Server Community Blogs] SQL Server Technical Roll up for July 2009 - Tony Rogerson's ...: The latest features and functionality included out-of-the-box with SQL Server 2008 will allow IT managers to save a tremendous amount of money and at the same time reduce management costs, hence it is worth the investment and you should upgrade to SQL Server 2008. 

[Mike H. - Another Geek In Need...] Clustered Enterprise Single Sign-On Deployment: Host Integration Server installs a newer version of the Enterprise Single Sign-On service, so we use HIS to setup our clustered SSODB and related service. Otherwise the HIS remote servers will fail indicating that the database is an older version and must be upgraded before proceeding.

[TechNet Blogs] Heavy on the Technical : SQL Server Info for the Month of April: SQL Server Migration Assistant (SSMA) 2008 for Sybase PowerBuilder Applications is a tool that cuts the effort, cost, and risk of migrating PowerBuilder Applications designed for Sybase ASE to SQL Server 2008. With SSMA for Sybase PowerBuilder Applications, IT organizations now not only have the freedom to migrate their database servers to SQL Server and take advantage of SQL Server's exceptional security, scalability, developer productivity, and the industry’s lowest total cost of ownership.

[uCertify's learning platform] MCITP 70-444 Short Notes: Exam passing Tips | uCertify's learning ...: Server Browser service is a tool used to connect to an SQL Server instance if a DBA is not able to connect to that instance through DAC. It can be configured either during the installation of SQL Server or by using the Surface Area Configuration Manager tool.

[TechNet Blogs] Technical RollUp : May 2008 - Technical Rollup Mail - SQL: SQL Server Migration Assistant (SSMA) 2008 for Sybase PowerBuilder Applications is a tool that cuts the effort, cost, and risk of migrating PowerBuilder Applications designed for Sybase ASE to SQL Server 2008. With SSMA for Sybase PowerBuilder Applications, IT organizations now not only have the freedom to migrate their database servers to SQL Server and take advantage of SQL Server's exceptional security, scalability, developer productivity, and the industry’s lowest total cost of ownership.

Reflected tags on Technorati: Blog, Sql Server Restore Database, Data Recovery Reports