Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2008 - BULK INSERT - In Recovery

Author  Topic 

chitti_babu
Starting Member

1 Post

Posted - 2011-06-30 : 05:12:06
Hi Gurus,

As you see I am new to SQL Sever, with Oracle and DB2 background.

I am doing loding fixed format delimited COBOL data files into SQL server using BULK INSERT T-SQL statements in SSMS. After 7 or so loads the load fails due to buffer pool issues? Is it due to temp db size?

Also, database is going into 'In Recovery' mode in the morning after this happens and happened this morning for second time. Any ideas, what should I do?

Regards
   

- Advertisement -