mirroring possible with 2000 - 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

General SQL Server Forums

New to SQL Server Programming

mirroring possible with 2000

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-25 : 08:10:31

Dear All,
is it possible to create mirroring between 2005 and 2000 version servers? both are enterprise editions?
and is it possible to create mirroring between 64 bit sql server 2005 and 32 bit sql server 2005?

please guide me

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-25 : 08:19:16

1)No
2)Yes,you can do either way 32-bit and 64-bit.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-25 : 08:31:00

thank you very much sodeep, one more doubt.
for my application, server005 mydb is the dataabase which is principal in mirroring
suppose unexpectedly the server failed. then will that automatically works with server007 mydbmirror which is the mirror database?
or we need to configure that manually?

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-25 : 08:33:05

It will change automatically if you do DBmirroring with Automatic failover but it will give performance issues with High OLTP environment. You application will failover too but there is some limitations.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-25 : 08:38:35

as i'm working for an emergency organization, and perday 70000 rows will insert in the database. i've already creaed replication. there is no burden on database except writing and a fewer people accessing. all the reports are generating in the replicated server. now i'm thinking of making the main server as principal, and on a test server i want to make the mirror. when it fails, the application should work depending on the test server. please suggeset me the best approach for this kind of environment

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-25 : 08:44:51

" now i'm thinking of making the main server as principal, and on a test server i want to make the mirror. when it fails, the application should work depending on the test server. please suggeset me the best approach for this kind of environment"

Arnav,
This is really bad thought to make Test server as Mirror. Well Replication and Database mirroring should never be done from primary server(production) to Test server coz its performance intensive. Also since you have already done replication ,you can't do DB mirroring because Mirror has to be in NORecovery mode.Go with replication for now.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-26 : 21:59:24

If you like to go mirroring, you can create db snapshot on mirrored for reporting.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-26 : 23:10:23