.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

SQL disaster recovery

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


What is the best practise for SQL 2005 disaster recovery. Pls. assist.

Best Regards,


Prasanna Nayak

View Complete Post

More Related Resource Links

Welcome to the SQL Server Disaster Recovery and Availability Forum

(Edited 8/14/2009 to correct links - Paul)Hello everyone and welcome to the SQL Server Disaster Recovery and Availability forum. The goal of this Forum is to offer a gathering place for SQL Server users to discuss: Using backup and restore Using DBCC, including interpreting output from CHECKDB and related commands Diagnosing and recovering from hardware issues Planning/executing a disaster recovery and/or high-availability strategy, including choosing technologies to use The forum will have Microsoft experts in all these areas and so we should be able to answer any question. Hopefully everyone on the forum will contribute not only questions, but opinions and answers as well. I'm looking forward to seeing this becoming a vibrant forum. This post has information to help you understand what questions to post here, and where to post questions about other technologies as well as some tips to help you find answers to your questions more quickly and how to ask a good question. See you in the group! Paul RandalLead Program Manager, SQL Storage Engine and SQL Express Be a good citizen of the Forum When an answer resolves your problem, please mark the thread as Answered. This makes it easier for others to find the solution to this problem when they search for it later. If you find a post particularly helpful, click the link indicating that it was helpful What to post in this forum I

Disaster Recovery replication topology

I've been trying to figure out the best way to set up replication for our Disaster Recovery. Currently we have five production databases replicating through five distributors to one data warehouse. We're looking to recreate the same set of servers with replicated data for our Disaster Recovery, but I can't figure out the best approach. We are using Server 2003, SQL 2005, and transactional replication. Between our production and Disaster Recovery, we are sharing a 45Mb/sec tunnel. Here are the scenarios I've come up with: Scenario 1: Replicate the production databases to our Disaster Recovery databases using the original publications and distributors. Then using our Disaster Recovery distributors, create new publications from the replicated databases and replicate again to our Disaster Recovery Data Warehouse. With this method I've encountered a couple problems already. First, our two busiest databases can not keep up over the WAN after the snapshot is delivered (i.e. latency continues to grow). and second, so far I haven't been able to replicate a replicated database, and I'm not even sure it is possible. Scenario 2: Use the original production databases and configure our Disaster Recovery distributors to replicate to both our Disaster Recovery databases and our Disaster Recovery Data Warehouse. This means adding a second distributor for each original publisher, and

Restoring a Service Application on Different Farm for Disaster Recovery


Hi All,

We are testing the Disaster REcovery scenario for SharePoint 2010 in multi-tenancy environment. The process I did is:

1. Created a sharepoint environment in a multi tenant scenario ( partioned the services while creating) and created few tenants with 1 or 2 site collections. (Parent Farm)
2. Created another environment with the same partioned mode. (DR Farm)
3. Tried to copy the site collection which is utilizing the Managed Metadata and restore it in DR farm along with the Parent Managed Metadata.

Everything is restored without error in the DR Farm (Site Collection and Service application and proxy). But, when I go to the term store (in tenant) I see a message like below:

"The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator. "

Also, the document library's managed metadata column value which was referring to the Managed Metadata it's greyed out (Read-Only).

My question is:  How can I restore the service application and make it work and also how can i associate the site collection to use the Service Application which it was referring to previously.

I don't know if I need to restore the subscription also. I am not able to get enough information. In TechNet, w

How to implement backup/disaster recovery for our product?


Hi Guys,

Ive been tasked with researching adequate backup procedures for a bit of web software that we sell. Its basically a website and an express sql database that is deployed onto a customer server. Over the time the databse will fill up with conent and we want to be able to advise the customer how they can back our software up.

Im wondering we could do nightly backups of the sql server but can this be automated with sql server management studio express?

If not can we do replication or databse mirroring?

Anyway any help would be much appreciated not sure what the best approach is.



Sharepoint 2010 Passphrase Not Connected To Farm - Disaster Recovery



A few weeks ago i made a sql backup of all the sql 2008 database (just SharePoint dbs).
Lost that server. Had .baks on a backup drive offsite.
I restored the databases to a new windows server 2008/microsoft sql 2008 database server. I can connect to sharepoint_config.... but without knowing the passphrase I’m stuck.
I’m not sure what the passphrase is and resetting isn’t working (using SharePoint power shell ) due to me not being connected to that farm.

Anything i can do here? Thanks for any help that can be provided.

What is the best for Disaster recovery for Merge



I've got one Database Server sql 2005, which play also the role of the publisher ; with actually 50 databases.
Each database contains 2 publications (one for desktop, and the second for windows mobile).

This is merge replication.

The way of sync is done with IIS (sqlcesa.dll and replisapi.dll)

I want to be able to be ready if something occurs on my servers.

About the IIS, it's not a problem I guess I can easily duplicate them.
I've got also night backup (.bak) of all the database.

But about the SQL Server database with merge publication, how can I solve the troubles :"my sql server crashs" ?

I read something about peer to peer replication ; is it the solution ? I mean, i create a peer to peer replication between 2 servers on the datacenter.  Then I add checks on my applications to be able to switch from server A to B if problem.And if one crash, I just have to work with the second ; and as soon as the first server is reinstall I just reconfigue the peer to peer between the servers ?

Or is there other solution when there is replication on the server ? (I mean; if it was just a simple database, i'm sure there are easy steps for this).

I want to have a solution that will bring me a service level quality very high if something wrongs happens.



Data Recovery Software

Nokia mobile phone bulk SMS sending software sends unlimited text messages through a GSM based mobile phone connected with your computer system to other mobile phone. Bulk message broadcasting application sends business related messages, notifications, personal SMS, share market information, enterprise advertising news etc to any group or individual in a single click.
Group messaging wizard offers latest and advance technology to create and sends bulk text messages/SMS from your computer system or laptop/desktop via GSM based mobile phone to another mobile phone worldwide. Instant SMS sending software easily and smoothly works with all popular GSM mobile phone brands including LG, Nokia, Samsung, Sony Ericsson, Motorola etc. Nokia mobile phone mass SMS sending tool facilitates you to have strong relationship with your family, friends, customers etc.
GSM mobile phone SMS sending program is very useful utility for all small or large business enterprise to increase their business by sending event alerts, notifications, advertising to individual or group of customers. Mass messaging software provides solution to the user to send multiple SMS through GSM mobile phone connected through PC to nationally or internationally network based mobile phones.

SharePoint: Add a Recycle Bin to Windows SharePoint Services for Easy Document Recovery


Windows SharePoint Services helps improve collaboration and workflow while protecting documents and intellectual property. But one feature is conspicuously missing - an easy way to back up and restore deleted files from document libraries. In this article, the authors take advantage of the extensibility of WSS and its server-side and client-side object models to build a restore feature that works like the Recycle Bin in Windows Explorer.

Maxim V. Karpov and Eric Schoonover

MSDN Magazine February 2005

execute update timedout expires , table with trigger due to recovery of database


I have table A in database A  , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean ret

Password recovery by entering email not username



I am using the ASP.Net password recovery control.  By default the user needs to enter their username before an email gets sent out to them.

If it possible instead of entering the username, email is used instead?  Alot of my users forgets their username but not email.


Database in recovery

Our server ran out of disk space during a stored procedure process. We were able to free up some space, stopped all SQL services, restarted all SQL services and now SQL Management Studio shows the database to be in recovery.  Is there a way to monitor this to ensure progress is being made and to estimate when it might complete?

My Sql server 2005 Database in recovery mode for 3 -4 hours every day

Hi , Some of our Sql Server 2005 databases remain in recovery mode after midnight for almost 3 to 4 hours. So when my application access them error "Databse in recovery" and for same database this happens again and again every night. Please suggest why and how this can be solved?

LDF File Disaster in SQL Server 2008

I am working on a startup company and the "dba" recently quit...come to find out he let the LDF file grow to 105GB - which effectively shut down the server due to lack of disk space.  I need to serious help as this database is also supporting our replication system and thus I cannot do anything drastic like detaching, deleting the LDF file and reattaching. I tried the shrink file option but the LDF file did not shrink at all.  I set the recovery model to simple, then tried shrinking and that did nothing.  This is a SQL Server 2008 machine - can somebody please help? Also, given that I am mainly a developer, is there some EASY reference on how to setup log file backups so this does not happen in the future?  Do I just perform a full backup every 30 minutes over-writing the previous backup, differentials, what? Thanks!

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential cau

Attempting to upgrade from SQL 2005 EE to SQL 2008 EE on Vmware ESX 3.5 virtual server. below is info from Detail.txt related to successful install with failures... 2010-09-02 13:50:46 Slp: Sco: Attempting to check if file 'D:\Data\MSSQL.1\MSSQL\LOG\ERRORLOG' exists 2010-09-02 13:50:46 Slp: Sco: Returning security descriptor O:BAG:SYD:AI(A;ID;FA;;;S-1-5-21-3788118842-658835432-3441893140-1006)(A;ID;FA;;;S-1-5-21-3788118842-658835432-3441893140-1007)(A;ID;FA;;;BA)(A;ID;FA;;;SY)S:AI(AU;IDFA;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;WD) 2010-09-02 13:50:46 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC. 2010-09-02 13:50:46 Slp: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. 2010-09-02 13:50:46 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC. 2010-09-02 13:50:46 Slp: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. 2010-09-02 13:50:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql) 2010-09-02 13:50:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(St

Recovery of Database Disabled SQL Agent, Cannot Detach Database, Etc... Please Help

I am a beginner SQL user, as the company laid off the IT guy and I am stuck with this.  So I really need some help on this one.  Any ideas would be appreciated. I was doing a merge join command to put data from one database to another.  These are 60GB databases with valuable data.  Halfway through I was told by client to just stop the query.  I did this but it left the good database with a large 80GB log file. When I rebooted the machine the recovery of this database took 5-10 minutes...  Thus the SQL Agent disabled itself waiting for recovery.  After recovery was 100% complete with no errors SQL Agent will not restart.  I can do a force turn on using a "1" statement, but the SQL Agent log file says it is still waiting for recovery. In any event, I cannot detach the database because it says 1 user connected.  I cannot backup, drop, etc...  I saw in one forum a guy said to turn service off, copy database to a new location, turn service back on, delete the database, attach copied database...  But I am a little worried about deleting. Once again - I am a SQL newbie and really need a pointer on this one.  I need to free this database and get a it back to a normal sized log file. Advice???

Custom Password Recovery

HiI have been working with ASPNETDB for my Security for my website.I am trying to create a custom password recovery page that will reset my password and email it to me.I know there is a PasswordRecovery Function in VWD but I wanted to write my own as I want it do some extra stuff.I have almost completed and have managed to get the code to check for the username and then get the users question, it then displays the question and asks the user to enter the answer.Where I am failing is how to get the code to check if the answer entered is correct against the answer in the users record.There does not seem to be a built in function to handle this, I do not need the answer to be decrypted or anything just want to compare it to the one entered by the user.Please help.Thank you in advanceRonnie

SharePoint 2010 Content DB Recovery Model

Hello Everyone, the following link states that the content db for SharePoint 2010 uses simple recovery model. http://technet.microsoft.com/en-us/library/dd207314.aspx   whereas this link at SQL Server documentation says that Simple model is not suitable for production systems because it has risk of data loss http://msdn.microsoft.com/en-us/library/ms189275.aspx   These two look totally contradictory to me.  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend