<div>
Ok thanks.<br />
<br />
I don't at present want to affect the way the live database is running.<br />
<br />
Just the copy I have taken to make it more manageable.<br />
<br />
I'm looking into shrinking the database now based on another question but am getting timoeout errors!
</div>


Ok thanks.

I don't at present want to affect the way the live database is running.

Just the copy I have taken to make it more manageable.

I'm looking into shrinking the database now based on another question but am getting timoeout errors!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
On a server there is a database which has a ridiculous amount of records in.<br />
<br />
I have made a copy of it and truncated a table that 88 million records in.<br />
<br />
The .mdf file is now 7.8gb and the .ldf is 27gb.<br />
<br />
I'm not muc of a dba, I'm a developer and need to get a copy of this database back to me local machine where I have sql server 2008 express.<br />
<br />
I'm downloading 2008 express r2 to get the 10gb allowance but will the log file size stop me?<br />
<br />
I only need this database for testing and analysis purposes so is there a way of not even including the logs?<br />
<br />
I imagine trying to take copies of large databases is a common problem so would appreciate some advice on the best way to get this back to my local machine.<br />
<br />
Thanks
</div>
</div>


Hi,

On a server there is a database which has a ridiculous amount of records in.

I have made a copy of it and truncated a table that 88 million records in.

The .mdf file is now 7.8gb and the .ldf is 27gb.

I'm not muc of a dba, I'm a developer and need to get a copy of this database back to me local machine where I have sql server 2008 express.

I'm downloading 2008 express r2 to get the 10gb allowance but will the log file size stop me?

I only need this database for testing and analysis purposes so is there a way of not even including the logs?

I imagine trying to take copies of large databases is a common problem so would appreciate some advice on the best way to get this back to my local machine.

Thanks

making a copy of a large database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.