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,


more ▼

asked Dec 14, 2009 at 02:06 PM in Default

avatar image

15 2 2 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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 :) )

more ▼

answered Dec 14, 2009 at 02:13 PM

avatar image

Kristen ♦
2.2k 7 11 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 14, 2009 at 02:06 PM

Seen: 1154 times

Last Updated: Dec 14, 2009 at 02:06 PM

Copyright 2018 Redgate Software. Privacy Policy