Synchronize two DataBase - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Replication (2008)

Synchronize two DataBase

Author

Topic

arnabsaha1981
Starting Member

5 Posts

Posted - 2011-12-15 : 01:44:32

Hi,

I want to Synchronize two database. The databases will be same. I have restored same database with two different name. Now i want to use the 2nd database for reporting. and that database should not be in read only mode. now please guide me how to Synchronize the two database

Thanks
Arnab

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-12-15 : 02:39:54

Please refer High Availablity Concepts in SQL SERVER

1.Logshipping
2.Mirrioring (snapshort for reporting)

Logshiping will suits you better and easy to configure and maintaince.

Senthil.C
------------------------------------------------------
MCTS - [Microsoft][ODBC SQL Server Driver]Operation canceled

arnabsaha1981
Starting Member

5 Posts

Posted - 2011-12-15 : 05:52:44

but for log shipping the 2nd database will be in Recovery mode or in Standby mode . in both cases we can not create any temp table in the 2nd database.

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-12-15 : 06:35:06

In Standby mode you can access your Database for read-only purpose.

If you really need any temp table create on both ends. (Primary and Secondary)

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

arnabsaha1981
Starting Member

5 Posts

Posted - 2011-12-15 : 07:43:11

what should i do If i need any temp table create on both ends. (Primary and Secondary)?

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-12-15 : 07:57:10

Just go through how logshipping will works.

Its database level availablity technique, all the objects from primary DB will be copied into secondary DB

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

arnabsaha1981
Starting Member

5 Posts

Posted - 2011-12-15 : 08:16:39

but in log shipping the secondary database will be in read only mode .. but when we create report some temp tables are created . then how should i do that?

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-12-15 : 08:26:49

Temp tables are going to created in tempdb rite, so you should not worry about. Create a sp that have all your business logic including temp table in primary DB and execute the SP from Secondary DB.

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

arnabsaha1981
Starting Member

5 Posts

Posted - 2011-12-15 : 09:32:59

If i create all temp table in y primary database then should we get better performance? as we are doing this only for reporting..

is SQL replication works in our case?

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2011-12-15 : 21:33:31

Using Peer To Peer replication

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources