Hi,
I'm using SQL server express edition in my official laptop ,I got a database of 35 GB from my team. when i try to restore in my laptop,It is not allow to restore more than 10 GB because it a express edition.
So, I installed SQL server standard edition trial version in my another laptop,then i restored there.
what i want to do is,i have to shrink the database size less than 10 GB ,then i have to restore in my official laptop
What I have tried:
I have tried to shrink my database ,the file sizes are below
.mdf : 19 GB<br />
.ldf : 15 GB
I removed some unnecessary tables,then i shrink-ed , It took around 3 hours to shrink the database.
After shrinking ,
.mdf 10.6 GB,<br />
.ldf 19 GB <br />
Again i tried to remove few tables ,truncated some large table data's and all.
but shrinking is not happening the
.mdf
size still in 10.6 GB. but no matter of removing log files,i want to shrink the data file mainly.
How can i do this?