Asked By
Jeo Tolbert
0 points
N/A
Posted on - 09/22/2012
I may sound dumb and idiot in this question but I badly need help from this forum.Â
Well I have been trying to follow different suggestions and procedures on how to get dump exam SQL server 2008 but I ended up empty handed.Â
Can someone here provide a detailed information on how to do it for me?Â
Please generate dump exam B5960sql server 2008
Hi there Jeo,
There are no dumb questions. I will try my level best to help you in anyway i can.Â
I am more familiar with MySQL Server but I after tickering with SQL server '08 I found it quite similar, albeit with subtle differences.
Â
The queries for dumping are
-
Set to simple mode alter database [name] set recovery simple;
-
Shrink the db dbcc shrinkfile ('LogicalFile_name', 1);
-
Set back to FULL (optional depending on backup method used) alter database [name] set recovery full;