September 6, 2008 02:57pm pdt

1. chapmandew 120,110
2. acperkins 73,004
3. nmcdermaid 56,964
4. cs97jjm3 33,643
5. brejk 30,000
6. PedroCGD 29,580
7. angelIII 27,585
8. frankytee 24,691
9. mark_wills 24,185
10. EugeneZ 18,950
11. dready 18,000
12. bhess1 15,550
13. Zberteoc 13,050
14. matthews... 12,250
14. rickchild 12,250
16. JimFive 8,375
17. MohammedU 8,325
18. aneeshatti... 7,802
19. momi_sa... 7,750
20. dbbishop 7,300
21. pratima_... 7,150
22. ptjcb 7,120
23. paulop1... 7,100
24. TheLearn... 7,000
25. dbaSQL 6,815

1. acperkins 341,253
2. nmcdermaid 169,681
3. angelIII 168,001
4. arbert 149,684
5. chapmandew 120,110
6. EugeneZ 69,768
7. matthews... 50,304
8. aneeshatti... 41,799
9. cs97jjm3 40,173
10. ptjcb 38,638
11. rboyd56 37,425
12. bhess1 35,130
13. PedroCGD 31,080
14. brejk 30,000
15. dready 28,430
16. Sirees 27,902
17. twoboats 27,515
18. frankytee 27,441
19. jltoops 27,275
20. Yveau 25,800
21. mark_wills 24,185
22. TommyTupa 23,000
23. Lowfatsp... 22,395
24. Kevin3NF 20,630
25. imran_fast 20,539

06.14.2008 at 08:45AM PDT, ID: 23485155

	[x] Attachment Details

SQL 2005 - Export / Import - Wizard get an ERROR ( A buffer failed while allocating ...)

Asked by MaxC07 in MS SQL DTS, SQL Server 2005

Tags: Microsoft, SQL Server 2005, 9.0.3042, 32 bit on MS Win2003 R2 Enterprise server / Clustersyste, HP, Pro Liant DL 585, Clustersystem / 8 GB RAM attacht to a SAN, * ERROR : errorCode=-1073450990 description=A buffer failed while allocating 10485760 bytes

I tried to export all data from a DB to a new one on the same server.
My steps:
Create DB
Create tableschema
create users
set loggin from new db to simple
start export / import wizard
select all needed table ( not the views)
start

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 ?

br

Start Free Trial

Attachments:

Report1.txt (11 KB) (File Type Details)

Reportfile first try

Report2.txt (4 KB) (File Type Details)

Reportfile f2nd try

Keywords: SQL 2005 - Export / Import - Wi…

	Title
1	char buffer insertion.....
2	How to really disable windows XP pag…
3	Pagefile use on server.
4	Allocating a buffer
5	Heap allocation error in C++ code
6	loggin in

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL 2005 - Export / Import - Wizard get an ERROR ( A buffer failed while allocating ...)

Asked by MaxC07 in MS SQL DTS, SQL Server 2005

Tags: Microsoft, SQL Server 2005, 9.0.3042, 32 bit on MS Win2003 R2 Enterprise server / Clustersyste, HP, Pro Liant DL 585, Clustersystem / 8 GB RAM attacht to a SAN, * ERROR : errorCode=-1073450990 description=A buffer failed while allocating 10485760 bytes

About this solution