June 21, 2010 at 2:59 pm
Hi,
I got a database of 20gb . Now i want to perform ETL process on that database so as to copy that entire database into another server.Approximately how much time it will take for that job to be completed.
June 21, 2010 at 7:05 pm
tripri (6/21/2010)
I got a database of 20gb . Now i want to perform ETL process on that database so as to copy that entire database into another server.Approximately how much time it will take for that job to be completed.
Since the plan appears to be to refresh 100% of the database I would call it extreme ETL 😀
Answering your question... how long it takes to take a full backup and restore of your database? The elapsed time is your answer 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 22, 2010 at 4:40 am
Have to agree with Paul.
ETL for a whole db doesnt really make sense.
Backup and restore would be a good idea.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 6:06 am
Since you're copying the entire database, why not simply run a backup and restore?
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 23, 2010 at 6:32 am
tripri (6/21/2010)
Hi,I got a database of 20gb . Now i want to perform ETL process on that database so as to copy that entire database into another server.Approximately how much time it will take for that job to be completed.
How often and why do you want to do this?
Maybe what you are looking for is log shipping or some other form of replication.
As for the how long - try a 2gb file as a test. How fast depends a lot on your hardware setup.
I got about 100GB in 30 minutes in my environment when I recently did that for a server build.
Greg E.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply