English 中文(简体)
Msg 3151: the database that was dumped was not quiescent when the dump was performed
原标题:
  • 时间:2010-02-24 19:38:06
  •  标签:
  • sap-ase

I am working on loading database dumps to a new ASE server, but when I try to load 15gb and 32gb dumps to a database, I get the below error:

Msg 3151, Level 16, State 2: Server TestServer , Line 1:

Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. Run sp_flushstats before DUMP DATABASE and ensure that the database is not updated during the dump.

When I load a 2gb dump to a db, everything is fine. I searched on the net and they advise to get db dump with sp_flushstats in single user more but I have no chance to get new dumps.

load database db1
from        compress::/home/aykut/db1_1 
stripe on   compress::/home/aykut/db1_2 
go

These dumps were taken from an ASE 12.5 instance located on a Solaris Sparc and I m trying to load these dumps in to an ASE 12.5 instance located on Linux x86. Is that causing an issue? Or can this error be related to ASE Developer Edition s database size limit?

最佳回答

Read official docs about crossplatform dump.

PS: You must redumped database. Before dump you must run DB in singlemod and call sp_flushstats. After database loaded - dbcc reindex, update statistics, sp_recompile.

http://www.sybase.com/detail?id=1033627

问题回答

暂无回答




相关问题
Linq 2 Sybase ASE database? What are the options?

I have a need to query an existing Sybase ASE database and would like to use Linq syntax for my data retrival. I don t need write access, nor do I need the full set of Linq operators, just Select(), ...

ASE Sybase BLOB

hi I want to write a file into a column of a blob data type,can some one pls send me the syntax for it. Appreciate if you could also send me the syntax for retrieving the file while doing the select ...

Sybase JConnect: ENABLE_BULK_LOAD usage

Can anyone out there provide an example of bulk inserts via JConnect (with ENABLE_BULK_LOAD) to Sybase ASE? I ve scoured the internet and found nothing.

About Sybase image

Does image data type be converted to byte array in sybase? I apply web service to get data set in sybase( image data type). I use byte[] to get returning of web service. Then i use the "response....

热门标签