Home Forums SQL Server 2008 SQL Server 2008 High Availability What are ways of Exporting data of Wahehouse Database from Production to Development Server? RE: What are ways of Exporting data of Wahehouse Database from Production to Development Server?

  • RTaylor2208 (9/5/2013)


    I suspect its because the DB is 100GB in size. And they may only need some not all of the tables in the database.

    The size is irrelevant. A restore is going to be faster and easier whether you're talking 100MB or 100 TB, as long as you're not intending to change much of the data/structures immediately afterwards.