I have the following dilemma. i currently have log shipping running between 2 locations over a t1 which works ok. now i need to have the standby database accessable to a special application the needs to read and write to the database. i am currently stopping the log shipping on a nightly basis and copying the mdf and ldf and attaching them. is there any better way that would be more efficient and not require me to take down my database on the far side on a nightly basis?
You would need to use replication for this. MeanOldDBA derrickleggett@hotmail.com When life gives you a lemon, fire the DBA.
If the data updation is required on the 2 locations continuously then as referred Derric you must deploy replication and stop the log shipping. http://www.databasejournal.com/features/mssql/article.php/1438231 http://www.databasejournal.com/features/mssql/article.php/1438201 ... articles for handy information. HTH Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I had the same situation once, I used Merge Replication to fullfill my purpose . i would recommend the same for you also. Thanks Sandy
