网站 › 『 Sybase ASE 』 › 在sybase客户端打开数据库报错误 database was either created for load or is sus...

ehxz 发表于 2013-5-14 09:09:23

在sybase客户端打开数据库报错误 database was either created for load or is sus...

1．以SA 身份用ISQL 登 录 到SQL Server

1>sp_configure "allow updates", 1

2>go

2>reconfigure with override

2>go

1>update master..sysdatabases

2>set status =-32768

3>Where name="database_name"

4>go

1>shutdown with nowait

2>go

2． 重新启动SQL Server, 再以SA身份登录到SQL Server.

1>update master..sysdatabases

2>set status=0

3>Where name="database_name"

4>go

1>sp_configure "allow updates" ,0

2>go

1>reconfigure with override

2>go

3. 重新配置

1>sp_dboption database_name,'trunc log on',true

2>go

1>sp_dboption database_name,'select into/bulkcopy',true

2>go

查看完整版本: 在sybase客户端打开数据库报错误 database was either created for load or is sus...