Database mirroring.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Database mirroring.

Database mirroring.

Rate Topic

Display Mode

Topic Options

Author

Message

subha.mcts2005

Posted Wednesday, January 05, 2011 2:08 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 72, Visits: 262

Hi,

we implemented database mirroring. the server name property is returning the name of the production DB server (ABC) instead of XYZ.

plz help me .

subha

Post #1042872

crazy4sql

Posted Wednesday, January 05, 2011 3:31 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 823, Visits: 3,314

if you run the hostname on dos prompt, are you getting xyz or ABC?
Also I beleive you saying that when you running select @@servername, you getting the incorrect server name.

If ABC is incorrect name then what exactly this server is?

----------
Ashish

Post #1042915

subha.mcts2005

Posted Wednesday, January 05, 2011 3:50 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 72, Visits: 262

Ok Asish,

i will check & update the status.

Subha

Post #1042925

« Prev Topic | Next Topic »

Permissions