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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-03 : 08:48:43
|
| Kari writes "OS: Win2000 SP3SQL: SQL Server 7 SP2Situation:Same routine as always. Exporting database (as a backup) prior to upgrade of software and database structure. Approx 100 tables, 600 SPsDTS details:Export to new DB - copy objects & data - take default settings except for 'use default options' - here we check 'copy sql server logins' DTS starts, everything looks good, gets to copying over tables to new database - gets to our MessageHistory table (contains BLOB field with zipped up wav file) - Approx 11,000 records in table. System REBOOTS during DTS at MessageHistory table. After reboot, check new database, all tables copied, but not all data - data stops at the MessageHistory table, did not even copy the first record into this table. We have run dbcc_checktable, finds no problem. Have tried other ways around this, none successful. This started a couple weeks ago with one customer - now, another customers system is doing the same thing. Is there a problem with exporting BLOB fields? Maybe related to the large number of records in the table? I know we have been able to do this in the past with no problem, but as time goes by, these history tables are getting larger. I am afraid we will start seeing more of our customers with this problem, which in turn, becomes our problem!!All ideas and suggestions will be very much appreciated." |
|
|
|
|
|
|
|
DTS export of database causes reboot at BLOB table