master库

93815200

免费乐捐，感谢支持

请问所谓的备份master库是不是就是把master.dat复制一份, 不用dump database备份呢.?

如用dump database备份,那如果master发生错误,不是不能用load database恢复节吗?

lllenxue

不是

MASTER数据库备份的时候，在DUMP之后，还要用BCP将系统表导出，不然load回去也不能用

load之后在用bcp导入系统表

93815200

请问如果是库出问题了,load 命令都不可以用,我还怎么导库呢.

flybean

不是

MASTER数据库备份的时候，在DUMP之后，还要用BCP将系统表导出，不然load回去也不能用load之后在用bcp导入系统表

[em12]
这种说法是不正确的。BCP备份系统表只是做第二次备份，以图更加保险。毕竟MASTER库是非常重要的。
下面的文字来自SYBASE手册之System Administrator Guide Volume 2　第27章　Developing a Backup and Recovery Plan之Scheduling backups of master：
System Administration Guide 865Scheduling backups of masterBack up the master database regularly and frequently.
Backups of the master database are used as part of the recovery procedure in case of a failure that affects the master database. If you do not have a current backup of master, you may have to reconstruct vital system tables at a time when you are under pressure to get your databases up and running again.
Dumping master after each changeAlthough you can restrict the creation of database objects in master, system procedures such as sp_addlogin and sp_droplogin, sp_password, and sp_modifylogin allow users to modify system tables in the database. Back up the master database frequently to record these changes.
Back up the master database after each command that affects disks, storage, databases, or segments. Always back up master after issuing any of the following commands or system procedures:
•disk init, sp_addumpdevice, or sp_dropdevice
•Disk mirroring commands
•The segment system procedures sp_addsegment, sp_dropsegment, or sp_extendsegment
•create procedure or drop procedure
•sp_logdevice
•sp_configure
•create database or alter database
Saving scripts and system tablesFor further protection, save the scripts containing all of your disk init, create database, and alter database commands and make a hard copy of your sysdatabases, sysusages, and sysdevices tables each time you issue one of these commands.
866 Adaptive Server EnterpriseYou cannot use the dataserver command to automatically recover changes that result from these commands. If you keep your scripts—files containing Transact-SQL statements—you can run them to re-create the changes. Otherwise, you must reissue each command against the rebuilt master database.
You should also keep a hard copy of syslogins. When you recover master from a dump, compare the hard copy to your current version of the table to be sure that users retain the same user IDs.
For information on the exact queries to run against the system tables, see “Backing up master and keeping copies of system tables” on page 24.
Truncating the master database transaction logSince the master database transaction log is on the same database devices as the data, you cannot back up its transaction log separately. You cannot move the log of the master database. You must always use dump database to back up the master database. Use dump transaction with the truncate_only option periodically (for instance, after each database dump) to purge the transaction log of the master database.
Avoiding volume changes and recoveryWhen you dump the master database, be sure that the entire dump fits on a single volume, unless you have more than one Adaptive Server that can communicate with your Backup Server. You must start Adaptive Server in single-user mode before loading the master database. This does not allow a separate user connection to respond to Backup Server’s volume change messages during the load. Since master is usually small in size, placing its backup on a single tape volume is typically not a problem.

93815200

上面的大哥，能不能搞点中英的，我英文不好，谢谢了。

[em06][em06][em06]

flybean

上面的大哥，能不能搞点中英的，我英文不好，谢谢了。

请自行参考中文手册，章节都很清楚了。

lllenxue

顶一下