question

boardtc avatar image
boardtc asked

DTS Export execution length/advice

I need to analysis a customer's sql server database, I don't have sql server myself. It's v8, pre SSIS, so I an looking at a dts export to excel, straight forward using the wizard.

The have a lot of tables so I am hoping to export them all as one excel file. The database shows in enterprise manager as 366mb. They access their database 24 7 so I am wary about locking/crashing it and don't know if that would be an issue.

Does anyone have an idea how long the export might take to run or any other observation/recommendations.

Thanks in advance,

Tom.

sql-server-2000exceldtsexport-data
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kristen avatar image
Kristen answered

How about take a Full backup, restore to a new, temporary, database and then any exports you do from there will be from a consistent moment-in-time and won't interfere with their live database.

Assuming that they have enough disk space ...

... first job after Restoring might be to SHRINK the new temporary database, that would release any unused space.

... or you could just take the backup file off-site and restore on your SQL box and export etc. from there (assuming they are happy for the DB to go off-site - given that they are presumably happy for the XLS to go off site I reckon its as broad as it is long :) )

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.