Post reply

Logging into and Querying Read Only Standby Database

  • October 30, 2007 at 2:21 pm

    #122181

    We have a Java web application that needs to be able to login to and query a warm standby database. Our Java developer is setup using our test database without any problem; however, on the standby database when I connect via SSMS to test the authentication, I am unable to login because the default read only copy of the database can't be opened. so I know there will be issues when the app uses a JDBC connection to select and update the database.

    Does anybody have any experience with using standby (read only) databases for a web app?

    Thanks,

    -Ben

  • October 30, 2007 at 5:45 pm

    #746891

    You can create database snapshots to read the readonly db. Refer the below links.

    How to: Create a Database Snapshot (Transact-SQL)

    Creating Database Snapshot

    Deleting Database Snapshot

    Regards..Vidhya Sagar
    SQL-Articles

  • October 30, 2007 at 7:22 pm

    #746898

    Thanks Vidhya I will give that a try.

  • October 31, 2007 at 1:44 pm

    #747234

    After reading more about snapshots in BOL I don't think that is the solution I am looking for because this is an OLTP database and data would be being updated every second so snapshots are not practical unless I rebuild them every hour or so...back to the drawing board.

    Thanks for you help,

    -Ben

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply