Issues encountered during Sybase restore 20141219

1. Create a new backup server:

Click start ---->sybase------>sybase config-------> create backupserver

1.1Click CreateBackupserverafter that, give the backup server a name and click NextClick"Network Address"Click Add after you go in, adding the application server name and port number, separated by commas,(the port number is not used). Click Continue.

1.2After configuring the backup server, clickStart-->Sybase-->Dsedit UtilityClickin the menu barServer Object--->add--->Name the backup server you want to add(Backup server name)--->set the address of the backup server, double-click the right windowServer Address----->Add Application server name and port number,still separated by commas, click the Add button to add the successful, you can test the server, right-click on the right side of the window to selectPing Server

1.3 After two steps, click start ---- >sybase------>sybase Central   ----- 〉 Add remote server The first text box on the popup form is written syb_backup syb_backup is a keyword, the second selects the name of the backup server, and then clicks Next, until it is complete.

2. Backup service cannot start

Modify the registry to delete the following:
\\HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\Server\_BS

Delete the following registry key values:
\\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
Sybbck__bs

Restart Windows
Rebuild the backup service (no, I say how to build it ^_^) change the backup port to 5001.
Restart the computer, haha, see how.
Note: Be sure to change the port to 5001.

3, restore times wrong: can ' t open a connection to site ' Syb_backup '

The syb_backup corresponding srvnetname of the Master Library sysservers table is found to be inconsistent with the backup service name in Dsedit.

Then execute update sysservers set srvnetname= ' Xxx_bs ' where srvid=1

It is reported Ad-hoc updates to system catalogs not enabled. A user with System Security Officer (SSO) role must reconfigure System to allow this. Error

You only need to do sp_configure "allow update", 1 and then modify the sysservers table.

Then execute the LOAD database test from ' D:\test.dat ' and execute the online database test after completion!

Summarize:

1, error This error can first check if the Sybase bckserver service has started2, in Dsedit see can ping through backup service3, check the Master Library sysservers table Configuration4, such as in the backup database dump, the error is the same way to check5, the above statement can be executed in SQL advantage, also can be executed under the cmd command:

Isql-usa-ppassword-sservername

1>load database Test from ' D:\test.dat '2>goafter the recovery is successful, then execute1> online Database test
2> Go

Issues encountered during Sybase restore 20141219