Interview Questions - What is SQL Server Bloating

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

What is SQL Server Bloating

Feb 1 2012 3:55AM by Nirav

Question

What is SQL Server bloating?

Answer

A database that has a data file of a couple 100MB and the associated log file is 500MB in size! It Occurs when transaction log backups doesn't scheduled properly and this growth of log file Called Bloating. To solve this provblem Change Database Mode to Full or Bulked Recovery Mode.

Read More.. [32134 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: SQL Server - Rainbow Table
Next: What are the differentTrigger types in SQL Server

Nirav

37 · 5% · 1593

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"What is SQL Server Bloating" rated 5 out of 5 by 4 readers

What is SQL Server Bloating

Question

Answer

Your Comment