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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

replicate a standby / read-only database

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I have a database that is being replicated with log shipping. The database is in Standby/Read-only mode. The logs are restored every 30 seconds. For the logs to be restored all users are disconnected. But I want to have continuous read access to the replicated database. So I thought: why not replicate the replicated database? This second replication can happen on the same machine or on the same instance, the only purpose would be having a copy for continuous read access. I have looked at mirroring and transactional replication, but these things do not give me what. Is there a way of replicating a Standby/Read-Only database with continous read access to the replica? Thanks in advance, Frans

View Complete Post

More Related Resource Links

Change database state to / from Standby / Read-Only to Normal


I've got log shipping running as part of my DR strategy and the recovery database shows up on the DR server in Standby / Read-Only mode.  In the case of distaster how would I change the database from Standby mode into Normal mode?

The database is almost 10GBs and I'd like to test out a recovery while being able to then turn the database back into recovery mode after the test.  Is that possible?




Steve Berg

Follow Steve on Twitter

Failed to update database "Hist_OHLC_ASnapshot" because the database is read-only.

Hi there, I've got this ExecutionfailureException using the subroutine below. It's been suggested by Alok.   public void CreateSnapshotAlok ( string SourceDatabaseName )         {             ProvideSecurity.provideSecurity ( );             DoServer.GetSrvConnOrSwitch ( "master" );             /* This is to ensure that a database with same name does not exist which is not needed if one chooses unique name for snapshot each time.*/             if ( Globals.srv.Databases[ SourceDatabaseName + "_Snapshot" ] != null )             {                 Globals.srv.Databases[ SourceDatabaseName + "_Snapshot" ].Drop ( );             }             Database database = Globals.srv.Databases[ SourceDatabaseName ];             Database snapshot = new Database ( Globals.srv, SourceDatabaseName + "Snaps

Accessing database in STANDBY mode while log shipping

Hi,     I am testing with Log shipping, I have it setup and it is working just fine. The secondary database was restored with Standby mode and is readonly. I have no problem accessing and querying data from the secondary database but I noticed if changes are made to the primary and I am accessing the database when the restore step to the secondary runs it fails with the following error: Message2006-07-31 09:40:54.33 *** Error: Could not apply log backup file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\LogShip\CI_REPLICATION_TEST_20060731131501.trn' to secondary database 'CI_REPLICATION_TEST'.(Microsoft.SqlServer.Management.LogShipping) ***2006-07-31 09:40:54.33 *** Error: Exclusive access could not be obtained because the database is in use.RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) *** This appears to be because you can not restore to a database that is in use? How do you get around this? Is it possible? How do I query data from the secondary db without worrying about causing log shipping to fail? Do I not worry about it because at somepoint when Exclusive access is obtainable all the logs will be rolled forward, but this could create a wide gap in sychronization between the primary and secondary db's, say if someone or something does not properly log off. I guess I could disconnect all users prior to applying tlogs but that kind

Read Uncommited on a Replicated Database



MS SQL 2005 SP2.

The replicated database is used for reporting.  Selects only.  However, some of the queries take quite a while to complete and this causes the distributor to be blocked.


1)  On the particular queries that are long running (or maybe entire db) set isolation level to READ UNCOMMITTED.

2)  Set ALLOW_SNAPSHOT_ISOLATION on (for replicated db).  For long running queries SET TRANSACTION ISOLATION LEVEL SNAPSHOT.


1.  Even though replication only distributes committed transactions, could the process of applying the transaction still cause dirty reads?

2.  I am concerned about the overhead.  But, if I only allow snapshot isolation on certain queries, can I not be as concerned?


Thank You.


How to read PDF using Asp.net(C#.net) and store values in Database


Dear All,

Please try to guide me how to achieve this one. my application need to do reading the PDF document and want to store the values in Database.

Actually what happens is my customers sends me the OCR scanned copied in the form of PDF file. i need to read those scanned pdf files and store the customer information into my  table.

please try to help me how to do this..

Thanking uou,



Faild to update database , becouse the database is read-only.



I creat a WindowsFormsApplication that its name is Taxi_agancy

I attached a database file that its name is Taxi_Agency.mdf to my project from server explorer in Visual Studio . ( I add conection to data connections and select Microsoft SQL Server Database File) and in Database file name I enter my database file .

I created a stup project for it . When I install my application in another computer and I try to add some data to my Database from application interface I recieve this error :

Unhandled exception has occurred in your application . if you click countinue the application will ignore this error and attempt to continue . if you click quit the application will close immediatly .

Failed to update database "c:\program files\default company name\setup\Taxi_agency.mdf" because the database is read-only.

Windows 7 Phone Database Rapid Repository Create Read Update and Delete


Download the code and a fully working example application from http://rapidrepository.codeplex.com/


  1. Introduction
  2. Set up the Rapid Repository
  3. Create, Read, Update and Delete
  4. Database is read-only.



    I have been learning on how to use the new features of the .NET 2.0, and Well I using VS2005 and everything is pretty straight foward. I did a Membership webform where you log in and create users and roles etc. I installed the SQL Server 2005 express as my Data provider and thats where my Tables are. I used the aspnetsql_reg comand to integrate the server to this application. Anyway my problem started when i decided to copy my project to my IIS server and well when I run the app from the Browser tells me that he Database It's set to Read-Omly and therefore it cant update it. This happens right after log in. but then I open the App. on hte VS and it runs find.

    This is the error:

     Exception Details: System.Data.SqlClient.SqlException: Failed to update database "C:\INETPUB\WWWROOT\ESPM\APP_DATA\ASPNETDB.MDF" because the database is read-only.

    If anyone have any ideas I would really aprecciate.

SharePoint 2010 backup is failing - Error - "Unable to read full interval from database - Operation



I am having a problem backing up a site collection, when trying to backup the collection I get the following error "Unable to read full interval from database" and "operation is not valid due to the current state of the object".

The backup does run and manages to backup 182MB of the site collection and then the backup fails, it fails at the same point what ever backup method I use e.g. STSADM, Powershell or Central Admin.

I'm getting the same error whether I use CA "granular backup" or "Farm backup", and using either STSAMD or Powershell. I can backup CA or the mysite collection but not the Home Portal site collection. I even tried installing the commuvaults 2010 agents and running a commuvault backup but this is also failing. i have included the log file entry below.

Does anyone have any suggestions on what i can do to either fix the problem or an alternative way to backup the collection or farm, I am currently taking a full SQL backup but am not sure how reliable this is as I haven't tried to restore the sites. 

P.S. I am not using the "UseSQLSnapshot" parameter.

11/30/2010 09:34:25.23  OWSTIMER.EXE (0x17E8)                 

How to create a web service that read each records in a database


Hi there,

I would like to create a web service that reads each record in MSSQL and display it in a web control, any suggestions?

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.
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