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.