Please generate dump exam B5960sql server 2008

Asked By 0 points N/A Posted on -
qa-featured

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? 

SHARE
Answered By 10 points N/A #156449

Please generate dump exam B5960sql server 2008

qa-featured

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;

Login/Register to Answer

Related Questions