I tried to export all data from a DB to a new one on the same server.
set loggin from new db to simple
start export / import wizard
select all needed table ( not the views)
The DB has around 70 GB, one maintable has around 50 GB.
If I copy this table ( alone ore in compination with all others) the wizard errors: ( also see reportfile in attachment)
* ERROR : errorCode=-1073450990 description=A buffer failed while allocating 10485760 bytes
First I increased the pagefile.
After a short time I found some articles via Goggle regarding: DefaultMaxBufferSize
1) How can a set this parameter, and is /are there other parameters to set ?
2) Would this parameterssettings a way of working that leads to the desired results ?