Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

how to restore master database with sybase

nibble
Super Advisor

how to restore master database with sybase

guys, i wana transfer the db of server A to server b. b is already running... when i tried to restore the master database, i got this error

1> load database master from tape_0mn
2> go
Server 'TEST_SRVR', Line 1:
LOAD DATABASE must be used in single user mode if trying to restore the Master database.

any help on this? aside from master, i need to restore 5 or more dbs.. i use a tape for the dump file and both r with hpux11
1 REPLY
Highlighted
priya80
Super Advisor

Re: how to restore master database with sybase

Hi Nibble,

 

Did you manage to get a solution to this issue? I am facing the same issue as well.

 

Appreciate the help.

 

Thanking in advance.

 

Regards,

Priya