Please generate dump exam B5960sql server 2008

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? 

• Status: Open
• Question Views: 767
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software

Answered By Jenniah_Medalla 10 points N/A #156449

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;

About Jenniah_Medalla

Questions
1

Answers
8

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/23/2012
• Question Category: Server Software