If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Problems with Proxy Database

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-29-09, 13:57
Aguiar_pablo Aguiar_pablo is offline
Registered User
 
Join Date: Jun 2009
Posts: 1
Red face Problems with Proxy Database

Good afternoon, I'm new here and I'm a Junior DBA in Sybase, I'm from argentina and i'm sorry if my english is not so good
I hope somone can help me
I have a proxy database that in master..sysdatabases where the proxy exists has this values:
def_remote_type def_remote_loc status3
1 db.[db_name].. 4
I've read in Sybase page that the value in the column status3 MUST be 2 for a proxy DB.
I've made the change of that value but when I run an ALTER DATABASE FOR PROXY UPDATE that value come back to 4 an all the tables and its data dissapears...
HELP PLEASE!!!
THANKS A LOT!!
Reply With Quote
  #2 (permalink)  
Old 07-01-09, 00:52
erovij erovij is offline
Registered User
 
Join Date: Jun 2009
Posts: 15
Hi,

The status3 column in sysdatbase is 4 instead of 2 .(as u read in sybase books). But i think it is not a problem.
Can u please go through this link..
SyBooks Online I think it may solve your problem.

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On