SSIS - OLE DB - IBM DB2 - SQLDUMP - More Dumps Than Works....

I have a package which access a DB2 database and pulls data from a single table. I can't put a specific event on it, but the package has been causing a dump to occur on a rather regular basis. The really odd part is sometime when I add a data viewer on the output link of the OLE DB Source it works....then it starts to dump again a couple of executions later. There are not date/time values involved in the result set, just character strings. Default code page is set to 1252 and use default page is set to False....any ideas appreciated - this is really starting to drive me nuts!


View Replies



Can anyone tell me where I can find information about why sql server might be executing a stack and/or symptom dump?
That is, what are some of the conditions that might cause this. Every time I try to DBCC DBREINDEX on a certain table, stack
and symptom dumps occur and SQL Server remains incommunicado (can't connect, even locally) until I restart it. I'm going to try to fix the table by using
rename table, create new table (and dependent objects) , transfer data, and toast the original table. No problem, I've done that
before with smashing success. But, if this solves my problem, I'll still be no wiser about what it was that caused the problem in
the first place. Any suggestions, questions, comments, or even jeers would be appreciated.

View Replies View Related



Could anyone help about the following case? many many thanks in advance


1.    This problem will be happended for different but similar storeprocedures in transient manner. However, when we try to repeat the problem by running the procedure again, it work fines

 2.    However, the problem has happended again unexpectedly

 3.    The problem occurs in different server have similar environment (Window 2003 server and SQL Server 2000 SP4).


Following is the dump:

SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*   05/21/07 15:52:04 spid 57
*   Exception Address = 007EA027 (SQLExit + 00282530 Line 0+00000000)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred reading address 76A6F2F3
*    H p m s _ R p t  12 00 48 00 70 00 6d 00 73 00 5f 00 52 00 70 00 74 00
*  M t n _ 0 0 0 1 1  4d 00 74 00 6e 00 5f 00 30 00 30 00 30 00 31 00 31 00
*  2    @ P a r a m _ 32 00 00 00 0a 40 00 50 00 61 00 72 00 61 00 6d 00 5f
*   I d x   H      H  00 49 00 64 00 78 00 00 e7 48 00 04 04 d0 00 00 48 00
*  d 7 7 7 9 8 1 1 -  64 00 37 00 37 00 37 00 39 00 38 00 31 00 31 00 2d 00
*  9 9 d e - 4 6 6 1  39 00 39 00 64 00 65 00 2d 00 34 00 36 00 36 00 31 00
*  - 9 b 8 4 - 6 9 1  2d 00 39 00 62 00 38 00 34 00 2d 00 36 00 39 00 31 00
*  d a f 8 8 3 f d 2  64 00 61 00 66 00 38 00 38 00 33 00 66 00 64 00 32 00

*  MODULE                          BASE      END       SIZE
* sqlservr                       00400000  00CBAFFF  008bb000
* ntdll                          7C800000  7C8BFFFF  000c0000
* kernel32                       77E40000  77F41FFF  00102000
* ADVAPI32                       77F50000  77FEBFFF  0009c000
* RPCRT4                         77C50000  77CEEFFF  0009f000
* MSVCP71                        7C3A0000  7C41AFFF  0007b000
* MSVCR71                        7C340000  7C395FFF  00056000
* opends60                       41060000  41065FFF  00006000
* SHELL32                        7C8D0000  7D0D3FFF  00804000
* msvcrt                         77BA0000  77BF9FFF  0005a000
* GDI32                          77C00000  77C47FFF  00048000
* USER32                         77380000  77411FFF  00092000
* SHLWAPI                        77DA0000  77DF1FFF  00052000
* sqlsort                        42AE0000  42B6FFFF  00090000
* ums                            41070000  4107DFFF  0000e000
* IMM32                          76290000  762ACFFF  0001d000
* LPK                            62D80000  62D88FFF  00009000
* USP10                          75490000  754F0FFF  00061000
* comctl32                       77420000  77522FFF  00103000
* sqlevn70                       41080000  4108AFFF  0000b000
* NETAPI32                       71C40000  71C97FFF  00058000
* AUTHZ                          76C40000  76C53FFF  00014000
* COMRES                         77010000  770D5FFF  000c6000
* ole32                          77670000  777A3FFF  00134000
* XOLEHLP                        01600000  01605FFF  00006000
* MSDTCPRX                       61150000  611C7FFF  00078000
* msvcp60                        780C0000  78120FFF  00061000
* MTXCLU                         74F40000  74F58FFF  00019000
* VERSION                        77B90000  77B97FFF  00008000
* WSOCK32                        71BB0000  71BB8FFF  00009000
* WS2_32                         71C00000  71C16FFF  00017000
* WS2HELP                        71BF0000  71BF7FFF  00008000
* OLEAUT32                       77D00000  77D8BFFF  0008c000
* CLUSAPI                        74DE0000  74DF1FFF  00012000
* RESUTILS                       74EF0000  74F02FFF  00013000
* USERENV                        76920000  769E3FFF  000c4000
* secur32                        76F50000  76F62FFF  00013000
* mswsock                        71B20000  71B60FFF  00041000
* DNSAPI                         76ED0000  76EFEFFF  0002f000
* winrnr                         76F70000  76F76FFF  00007000
* WLDAP32                        76F10000  76F3DFFF  0002e000
* rasadhlp                       76F80000  76F87FFF  00008000
* NTMARTA                        77E00000  77E21FFF  00022000
* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
* SSNETLIB                       00E80000  00E95FFF  00016000
* security                       71F60000  71F63FFF  00004000
* crypt32                        761B0000  76242FFF  00093000
* MSASN1                         76190000  761A1FFF  00012000
* schannel                       76750000  76776FFF  00027000
* rsaenh                         68000000  6802EFFF  0002f000
* PSAPI                          76B70000  76B7AFFF  0000b000
* dssenh                         68100000  68123FFF  00024000
* hnetcfg                        5F270000  5F2C8FFF  00059000
* wshtcpip                       71AE0000  71AE7FFF  00008000
* SSmsLPCn                       00EF0000  00EF7FFF  00008000
* SSnmPN70                       410D0000  410D6FFF  00007000
* ntdsapi                        766F0000  76704FFF  00015000
* SQLFTQRY                       03410000  03435FFF  00026000
* xpsp2res                       10000000  102C4FFF  002c5000
* CLBCatQ                        777B0000  77832FFF  00083000
* sqloledb                       03450000  034D0FFF  00081000
* MSDART                         74A50000  74A69FFF  0001a000
* MSDATL3                        61200000  61214FFF  00015000
* oledb32                        03900000  03978FFF  00079000
* OLEDB32R                       037E0000  037F0FFF  00011000
* msv1_0                         76C90000  76CB6FFF  00027000
* iphlpapi                       76CF0000  76D09FFF  0001a000
* xpsqlbot                       03A00000  03A05FFF  00006000
* xplog70                        03020000  0302EFFF  0000f000
* xplog70                        03A10000  03A14FFF  00005000
* xpstar                         410F0000  4113CFFF  0004d000
* SQLRESLD                       42AC0000  42ACBFFF  0000c000
* SQLSVC                         04900000  0491AFFF  0001b000
* ODBC32                         04920000  0495CFFF  0003d000
* COMCTL32                       77530000  775C6FFF  00097000
* comdlg32                       762B0000  762F9FFF  0004a000
* odbcbcp                        60950000  60955FFF  00006000
* W95SCM                         41140000  4114CFFF  0000d000
* SQLUNIRL                       5BB30000  5BB5CFFF  0002d000
* WINSPOOL                       73070000  73096FFF  00027000
* SHFOLDER                       766D0000  766D8FFF  00009000
* odbcint                        04B20000  04B36FFF  00017000
* NDDEAPI                        75810000  75816FFF  00007000
* SQLSVC                         04C50000  04C55FFF  00006000
* xpstar                         04C60000  04C68FFF  00009000
* dbghelp                        04DB0000  04EAFFFF  00100000
*        Edi: 00000000:
*        Esi: 4A517478: 4A516020  4A517FF0  92CDD908  9D63AD4C  CB0EB00C  00000029 
*        Eax: 76A6F2F3:
*        Ebx: 4A517358: 00240024  00000010  00000000  00000000  47000002  00000000 
*        Ecx: 00000004:
*        Edx: 00000004:
*        Eip: 007EA027: CE8B108B  508B1189  04518904  8908508B  508B0851  0C51890C 
*        Ebp: 032F84E8: 032F8540  0075AD60  44E195C0  44DF6038  4A517308  032F8560 
*      SegCs: 0000001B:
*     EFlags: 00010206: 00740073  00720065  0063005C  0075006C  00740073  00720065 
*        Esp: 032F84C4: 44E195C0  4A517308  44DF6038  4A517478  4A517358  00000001 
*      SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 007EA027 Module(sqlservr+003EA027) (SQLExit+00282530)
* 0075AD60 Module(sqlservr+0035AD60) (SQLExit+001F3269)
* 008C222B Module(sqlservr+004C222B) (GetIMallocForMsxml+000CD6AB)
* 00461C5A Module(sqlservr+00061C5A)
* 004B817B Module(sqlservr+000B817B)
* 005DAE2A Module(sqlservr+001DAE2A) (SQLExit+00073333)
* 005DB09D Module(sqlservr+001DB09D) (SQLExit+000735A6)
* 005DA3AB Module(sqlservr+001DA3AB) (SQLExit+000728B4)
* 00461C5A Module(sqlservr+00061C5A)
* 004C680A Module(sqlservr+000C680A)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC024 Module(sqlservr+000FC024)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 00514181 Module(sqlservr+00114181)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 0048ED21 Module(sqlservr+0008ED21)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC024 Module(sqlservr+000FC024)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004C680A Module(sqlservr+000C680A)
* 00461C5A Module(sqlservr+00061C5A)
* 004FC000 Module(sqlservr+000FC000)
* 00461C5A Module(sqlservr+00061C5A)
* 004C680A Module(sqlservr+000C680A)
* 00461C5A Module(sqlservr+00061C5A)
* 0048ED21 Module(sqlservr+0008ED21)
* 00461C5A Module(sqlservr+00061C5A)
* 004885F1 Module(sqlservr+000885F1)
* 00461C5A Module(sqlservr+00061C5A)
* 00541A71 Module(sqlservr+00141A71)
* 00461C5A Module(sqlservr+00061C5A)
* 0048FCF1 Module(sqlservr+0008FCF1)
* 00461C5A Module(sqlservr+00061C5A)
* 00461D54 Module(sqlservr+00061D54)
* 00466407 Module(sqlservr+00066407)
* 004667DD Module(sqlservr+000667DD)
* 00466893 Module(sqlservr+00066893)
* 00464D29 Module(sqlservr+00064D29)
* 00464E1F Module(sqlservr+00064E1F)
* 00464FE7 Module(sqlservr+00064FE7)
* 004709F2 Module(sqlservr+000709F2)
* 00470A8F Module(sqlservr+00070A8F)
* 004786CF Module(sqlservr+000786CF)
* 0044DBE7 Module(sqlservr+0004DBE7)
* 0044D85C Module(sqlservr+0004D85C)
* 0043711A Module(sqlservr+0003711A)
* 005CF4AF Module(sqlservr+001CF4AF) (SQLExit+000679B8)
* 005CF7D1 Module(sqlservr+001CF7D1) (SQLExit+00067CDA)
* 00415E57 Module(sqlservr+00015E57)
* 0043CDDE Module(sqlservr+0003CDDE)
* 0043D005 Module(sqlservr+0003D005)
* 0042598D Module(sqlservr+0002598D)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E6608B Module(kernel32+0002608B) (GetModuleFileNameA+000000EB)
* -------------------------------------------------------------------------------

View Replies View Related


I am continually getting a sqldump EXCEPTION_ACCESS_VIOLATION and am required to reboot the server to fix the problem. The problem will occur at lease twice a week.

View Replies View Related

SSRS Works From SSIS

I would like to loop through a SQL Server table that contains the paths to all the reports(SSRS) we need to run and then execute the reports via SSIS. What task should I be doing to do this? Will the For Loop work for something like this? Anyone Please Explain how to do it . Or either Explain me how to run a Report(SSRS) from SSIS

View Replies View Related

SSIS Package Works, But Not In SQL Server Agent Job

I have a problem running an SSIS package in a SQL Server job. The package runs fine if I run it from the MSDB location, but if I try to run the job it fails. The job is set to Run as: SQL Agent Service Account. The SQL Service Agent service runs as a domain user SQLExec. I have logged in as this user and run the SSIS package and it runs fine, but if I create a job with only this step it fails. There isn't much information about where there is a problem. Any ideas or ways to troubleshoot this problem would be very much appreciated.

Thanks, john

View Replies View Related

SSIS: Oracle Import Works, But Not When Scheduled


I am running SQL Server 2005 and have built a simple SSIS package to import data from an oracle database to my SQL Server 2005 database.  When I run it in SSIS, it works and it imports just fine.  When I schedule it, it gives me problems.  Help!

It might be a problem with Oracle Provider client I installed.  Is there a client version I can download and install?  the one I downloaded from oracle doesn't work.  I bet i did something wrong though.

Here is my version:

Microsoft SQL Server Management Studio      9.00.2047.00
Microsoft Analysis Services Client Tools      2005.090.2047.00
Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML      2.6 3.0 4.0 6.0
Microsoft Internet Explorer      6.0.3790.1830
Microsoft .NET Framework      2.0.50727.42
Operating System      5.2.3790

Microsoft Visual Studio 2005
Version 8.0.50727.42  (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727

Installed Edition: IDE Standard

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 9.00.2047.00

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 9.00.2047.00

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 9.00.2047.00




View Replies View Related

How SSIS Works With Data Sources Other Than SQL Server?


I am new to SSIS.  I would like to know if I want to transfer data from one Oracle schema to another Oracle schema and also to do scheduling of the packages, can I still use SSIS?  If yes, what are the components that need to be installed on the database server and the development environment?  I hope I don't need the full SQL Server database installation in order to use SSIS.



View Replies View Related

SSIS E-mail Alert Only Works When Run Manually

If this is a duplicate post I apologise in advance as my search yielded many results about mail alerts but none like this.

The scenario is my SSIS package is scheduled to read data from a remote FoxPro source. If for any reason it fails I have set up an email task to alert internal users and an external helpdesk.

My problem is that if I am running it via Management Studio i.e. SQL Server Agent/Jobs/Start Job and I 'force a failure' by unplugging the network cable it successfully sends an email alert to all recipients (internal and external).  If I let the job execute according to the schedule (still with the network cable unplugged) the job fails (as expected) but no email alerts are sent.

I log onto the server with a valid domain user account who has administrative rights to the server as well as dbo rights on the SQL instance.  I deploy my package as the domain user and have checked that the domain user is also the 'owner' of the scheduled job.

I suspect it has something to do with ownership or which user is 'truly executing the scheduled job'.  Any ideas would be welcome.

Thanks in advance, Craig

View Replies View Related

DateAdd Expression Works In Tsql But Doesn't Work In Ssis

Hi There,

I am trying to set a variable with this default value using expression. This works in tsql but doesn't in ssis. Can anybody tell me what is wrong with this?


dateadd("dd", -1, datediff("dd", 0, getdate()))



View Replies View Related

SSIS Flat File Text Qualifier Only Works On Some Machines!

I have made a package that reads a text file into a table.
The data in the file is roughly as follows.
1, "a", "b,c,ddddd", 4, "ee", 0 with the column sizes int, 1, 50, int, 2, int
On all the desktop Bids environments and a SQL 2005 instance on windows server 2000 the package runs fine.
on the 2 Windows server 2003/SQL 2005 machines a truncation error occurs on col 5.
What is happening is on these machines the text qualifier is being ignored and column 5 is reading as ddddd instead of ee!
I figured this out by changing all fields to text and seeing what came out of the other end.
It is very, very strange and I've hit a brick wall.
If Anyone has any ideas throw them in the mixer please?

View Replies View Related

SSIS Processing Cube Task, Only IP Address Works, Put Server Name Will Get Error

I have an SSAS 2005 database "A" and SSIS package "P" which process full "A" olap database.
SSAS SERVER connection string is based on a variable read from XML configuration file.
It works well in BIDS, but when i deployed, the package failed at the step connecting SSAS, the message is "a connection cannot be made, please ensure the server is running"
In the connnecting string, i am using server name like, if I change it to IP address, it works.
if I change it to Localhost(happens to be on the same server), it works.
But I need the server name solution as IP may be changed.
I installed SP2.
Any suggestion?
Thanks and regards

View Replies View Related

SSIS - Process Task Exit Code 4 - Via SQL Agent Scheduled Job Only - Works If Manually Started....

We have a Process Task component setup in a couple SSIS jobs to call a command batch file to support transfering a file via Secure FTP to other servers and the process works fine if we start the SQL Agent job manually, however when the job is started via the scheduler, it fails with an exit code of 4. Even though there is a proxy setup on the agent job, is there a different user account being invoked by the scheduler??? We're on 2005 SP1 Hotfix 1 (2153). Thanks
Some more info...have found that if we leave a login session open on the server (login is the proxy account) the process works. It appears the issue is associated with a need to render/create a command window for the command line/batch process to run in and without an active windows session it fails....would seem to be that a product setup to run on a server in a batch mode would be able to work without this the case? if so, how? Thanks.

View Replies View Related

SSIS Package Hangs In Data Flow, Magically Works After Opening And Closing Components

We're experiencing a problem where intermittently our SSIS packages will hang.  There are no log errors or events in the event viewer.  It will happen whether the package is executed from the SQL Job Agent or run from BIDs.  When running from BIDs it appears to hang inside one of the data flows (several parallel pipes with sorts, merge joins etc...).  It appears to hang in multiple pipes within the data flow component.  The problem is reproducable, we just kill it and re-run, and it appears to hang in the same places.

Now here's the odd thing: as we simply open and close some of the components in the pipe line after the place it hangs, a subsequent run will go further in the pipeline before hanging.  If we open and close all the components after the point it initially hung, the data flow will run fine, from there on out.  When I say "open and close" I mean no changes are made, we simply double-click the component, like a merge join, then click 'close.'

To me this does not seem like a memory problem but likely something is wrong with the metadata, where opening a component and closing it somehow alters the metadata to "right it".

This seems to occur intermittently after we make modifications to the package.  It's like if you make any mod, even unrelated to the data flow, you then have to go through and open and close every component in your package to ensure it will work.  Again, no errors or warnings are fired.

Has anyone seen this type of problem?


View Replies View Related

How SSIS Works With Cluster SQL And Non Cluster SSIS Service?


According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED.

Now this is the situation that I have where I need to understand how SSIS works?

Enviornment: Active Active cluster enviornment for SQL server with SSIS server installed as stand alone as default on both node.

Name:   Node 1     Node 2
---------  --------------    ---------------------
Server name:  Nd1     Nd2
SQL server name: cs-nd1in01    cs-nd2in02
SSIS server name: Nd1     Nd2

BTW, this is cosolidated enviornment so there are more than one application expected and resides on each instance of SQL server.

The question is around SSIS, what would be the best practice to develop SSIS package that can work with above envoinrment.

Secnario: What if my Nd1 fails. SQL server cs-nd1IN01 will be failover to Nd2 and it will be available. But How about SSIS packages? How that understands
to use Nd2 SSIS as Nd1 SSIS is not available. Is anyone has similar experience to setup SSIS in cluster envionrment but as non-cluster service?

Please help. Thanks in adavance.

View Replies View Related

Need Of SQL Dumps

HiIam new to this groupSO can any one provide me with dumps of 1z0-007regdsAJax

View Replies View Related

Please Help Me Debug Hex Dumps

Hello gurus,

Our SQL Servers is giving us a headache, after a certain period in time, either SQL Service automatically shuts down by itself or hangs. I've opened the logs and found hex dumps. Can you help me out with these?

2007-07-08 04:04:35.20 spid53 SqlDumpExceptionHandler: Process 1760 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* ************************************************** *****************************
* 07/08/07 04:04:35 spid 53
* Exception Address = 0042D46D
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 6AF1EDF0
* Input Buffer 4088 bytes -
* lat_Meta_Data) DBCC DBREINDEX (SYS_Document_Meta_Data) DBCC DBREINDEX
* (SYS_Document_Meta_Detail) DBCC DBREINDEX (SYS_Documents) DBCC DBREIND
* HF_Document_Meta_Data) DBCC DBREINDEX (SYS_HF_MI_Emission_Results) DBC
* S_Document) USE Industry DBCC DBREINDEX (dtproperties) DBCC DBREIND
* _OperationCodes) DBCC DBREINDEX (RF_Unisys_ErrCodes) DBCC DBREINDEX (S
* YS_Admin_Has_Agents) DBCC DBREINDEX (SYS_Admin_Sharing) DBCC DBREINDEX
* (SYS_Companies) DBCC DBREINDEX (SYS_Company_Has_Admins) DBCC DBREINDE
* X (SYS_Company_Meta_Data) DBCC DBREINDEX (SYS_HF_Admin_Has_Agents) DBC
* ss) DBCC DBREINDEX (SYS_Pages) DBCC DBREINDEX (SYS_Password_History)
* sqlservr 00400000 00CBAFFF 008bb000
* Invalid Address 77F80000 77FFBFFF 0007c000
... <snipped>
* xpstar 09240000 09248FFF 00009000
* rsabase 092D0000 092F2FFF 00023000
* dbghelp 0AA80000 0AB7FFFF 00100000
* Edi: 0AA53937: 00000000 00000000 00000000 84004A00 98018901 C501B101
* Esi: 6AF1EDF0:
* Eax: 00000878:
* Ebx: FFFFE000:
* Ecx: 3FFFF800:
* Edx: FFFFE000:
* Eip: 0042D46D: CA8BA5F3 F303E183 DC7D8BA4 83D045FF 4D8B2CC7 E9D233E0
* Ebp: 0A1BFCC0: 0A1BFCE4 0042D5CD 71E428CC 71E40570 71E40988 0AA519A0
* SegCs: 0000001B:
* EFlags: 00010206: 00530053 0052004F 003D0053 00000034 0053004F 0057003D
* Esp: 0A1BFC28: 0AA519A0 71E4052C 00000000 00000010 71E408A0 00000010
* SegSs: 00000023:
* ************************************************** *****************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0042D46D Module(sqlservr+0002D46D)
* 0042D5CD Module(sqlservr+0002D5CD)
* 0042D6C7 Module(sqlservr+0002D6C7)
* 00508750 Module(sqlservr+00108750)
* 0051EB18 Module(sqlservr+0011EB18)
* 0051E9E4 Module(sqlservr+0011E9E4)
* 0085EACA Module(sqlservr+0045EACA) (GetIMallocForMsxml+0006A08A)
* 004229A7 Module(sqlservr+000229A7)
* 0087B87B Module(sqlservr+0047B87B) (GetIMallocForMsxml+00086E3B)
* 0087E3C9 Module(sqlservr+0047E3C9) (GetIMallocForMsxml+00089989)
* 0059A449 Module(sqlservr+0019A449)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 7C57B3BC Module(KERNEL32+0000B3BC) (lstrcmpiW+000000B7)
* -------------------------------------------------------------------------------
*Dump thread - spid = 53, PSS = 0x55a35280, EC = 0x55a355b0
*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0020.txt

*** Problems occur intermittently, sometimes after our full backup which occurs every 0000h, sometimes 30 minutes after our transaction log dumps.

Please advice me on my next step. Thanks

View Replies View Related

SQL 2K Dumps Via Network

Hi all,

I've read that the SQL dump can only be done directly into the local server. Is there a way to put directly the dump into another server via the network (not copying it but writing it during the process of backup).
Any help much apreciate.


View Replies View Related

Restoring Without Dumps

Hi !

I have one crashed database !

I have no dumps at all !

I have cold backup of the data files !!

Is it possible to just restore the datafiles and everything`s nice again ??

View Replies View Related

Problems Doing Dumps

Actually we have problems doing database dumps, so we're copying directly the .DAT files
to a backup machine, I mean the .DAT files are the data devices that uses SQL no dumps files.
We can do or eecute the dump process.

What problems can we expect doing this?
Which can be the problems 'cause we cannot dump our DB's?


View Replies View Related

Question Regarding Dumps

I have noticed a question on the Admin exam which involves declaring and usting a time variable for scheduling a backup or dump of a database. Is this possible and has anyone else seen this on the exam or used it in reality?

View Replies View Related

Transaction Log Dumps


I need to set up a dump of my main database's transaction log to dump every hour but not overwrite until the 8th hour (keeping 7 log dumps). Can anyone tell me how to set up the scheduled tasks for the transaction log dump? Is there anything special I need to do for the main database dump?

Thank you, Laurie

View Replies View Related

Automating Transaction Log Dumps

I am testing a procedure to automate the transaction log dump. I am following the steps located in Chapter 22 of the Microsoft SQL Server Administrator's Companion ("Automatic Transaction Log Dumps Using Performance Monitor"). The alert in Performance Monitor appears to be starting when the log is 75% full, but the alert is not firing off the file that contains the dump transaction sql command. For the 'Run Program on Alert' box this is what I have: isql -Ssvrname -Usa -P -id:appsmssqlinndump.sql
The dump.sql file contains: 'dump transaction pubs with no_log'

I have also tried the following 4 steps: 1) Created a SQL Alert Messsage, 2) Created an NT Performance Monitor Threshold Alert to run sqlalrtr to issue a certain error when the pubs log is 75% full, 3) Created a TSQL Task, and 4) Created a SQL Server Alert to run the Task created in step 3. This appears to do the same thing. The Alert is fired off, but the Task is never executed. Note: I am able to execute the task from within the Schedule Tasks Window.

I am using Standard Security with SQL Server 6.5 (sp5a) running on NT4.
Thanks for you help in advance.

View Replies View Related

High CPU During Tran Log Dumps

We are experiencng high cpu utilization across all 4 cpu's at the top of the hour when our transaction log dump job runs. Has anyone observed this bahavior before? Is there anything we can do to mitigate this? Thank You.

View Replies View Related

Exam 70-229 Preapration Dumps

Hi Forum,

I am new to microsoft SQL server as I am from Oracle background. I am preparing to the MCP certification for Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. The exam shows as SQL server 2000 is there any exam for SQL server 2005.

Is it the write exam to give to start as fesher into microsoft platform. Iam into development not towards administration.

If any body has any Exam preparation questions please forward them to



View Replies View Related

Elapsed Time Differences For Dumps

I have 6.50sp4 installed.
I have noticed significant differences in dump elapsed times for the same database.
It appears to be associated with whether a local drive dump file is used (eg D:MSSQLBACKUPBACKUP1.DAT) versus a UNC name for a local drive dump file (eg COMPUTERAD$MSSQLBACKUPBACKUP1.DAT) where ComputerA is the database

Has anyone found a way to get the local UNC dumps to run faster or a fast as the local drive dump files. I was hopping to convert to using only
UNC dump file names.


View Replies View Related

Check To Make Sure Dumps Are Not Corrupt

How can I check to make sure that my dumps are not corrupted? I have been using a utility from Microsoft called DSCAN5, but have found that this has some limitations.

View Replies View Related

Automate Load Of Transaction Dumps


does anybody know how to automate the loading of incremental transaction dumps. The manual way is to use the "load tran DB with FILE = x" statement.

Since this has to be done in the right sequence and i need to automate this task to keep a second server up to date i like to know if there is a stored procedure
or any other tool which could do the task.

Thanks for your help

Best Regards

Yorn Ziesche

View Replies View Related

Long-running Transactions And Log Dumps?


I am reviewing our backup strategy.

The application, running on mssql 6.5, sp4, involves long-running transaction intermittently during a given month but particularly so at month-end as this is a financial application written in Powerbuilder.

I have been thinking of including the dumping of the transaction log several times a day but I am concerned about the effect of a long-running transaction when the log has to be dumped. The result will probably hang the transaction or the dump; neither being the desired result. It's difficult to determine when the transaction willocur most times.

1) Has any one experienced something like this with long_running transactions and log dumps?

2) Any other thoughts on this?


David Spaisman

View Replies View Related

Cross Server Database Dumps

I am attempting to remember the string to dump/restore a database to a different physical server.

I have the database on Server 1 and want to back it up to server 2. Can anyone refresh my memory?


View Replies View Related

Copyrights 2005-15, All rights reserved