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  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Performance Issue

Author  Topic  deepa Starting Member 17 Posts Posted - 2001-11-05 : 07:32:57 I have a a very large database which need to be backed up say about 8 lac records and the problem is I have tried different approaches,say bulk copy, bulk insert,DTS .But I am not getting a faster backup as only a part of the data need to be backed up. so I will be using "where conditions" in my Select queries which slows down the back up process. Normally it takes an hour to back up 3 lac records with the where condition and the same without the where clause takes only 2 mins. And, my where clause is just the data range for a specific interval of time. Can anyone help me with any other way or links /topics which gives me details of pages/extents process. Need detailed information Deepa