Copy the system tables to data files as follows:
Execute the bcp...out command for each of the six main tables. At a Sybase bin directory prompt, enter:
bcp master..sysdevices out /directory.spec/devs -Usa -P -c bcp master..sysdatabases out /directory.spec/dbs -Usa -P -c bcp master..sysusages out /directory.spec/usages -Usa -P -c bcp master..syslogins out /directory.spec/logins -Usa -P -c bcp master..sysconfigures out /directory.spec/configures -Usa -P -c bcp master..syscharsets out /directory.spec/charsets -Usa -P -c
If your site needs other system tables, such as sysservers, and sysremotelogins, run bcp...out for them now as well. The syntax is:
bcp master..<table_name> out /directory.spec/<filename> -Usa -P -c
Where:
table_name is the name of the table, for example sysservers.
filename is the name you want to give the bcp file, for example srvrs.
For details on using the bcp command, see the Adaptive Server utilities manual for your platform.
You cannot use bcp and buildmaster to
recover user databases on the master device. You must manually drop
and reload these user databases from backups.
