general question about DB space

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » general question about DB space

general question about DB space

Rate Topic

Display Mode

Topic Options

Author

Message

harish_ravi

Posted Monday, November 17, 2008 3:50 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, August 09, 2009 11:55 PM
Points: 24, Visits: 76

Hi,

This is a question asked to my friend in Microsoft interview.

consider we have a SQL Server database in disk. Currently the disk is full(no empty space). And i am not willing to buy/replace this disk. Can you please suggest some tips to fetch some empty space. (Clue:- you can delete some log files)

If someone have any idea.. please share with me. :)

Post #603999

steveb.

Posted Tuesday, November 18, 2008 7:31 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:07 AM
Points: 2,802, Visits: 7,107

You can turn on simple recovery and shrink the transacation log, or you can shrink the database file.

Though neither of these are really recomended as SQL server uses as much space as it needs, and the files are likely to grow to the same size again.

Post #604387

Schadenfreude-Mei

Posted Tuesday, November 18, 2008 7:56 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, March 21, 2013 8:40 AM
Points: 1,099, Visits: 1,320

A stupid question really. Especially given MS's liking for disk-hungry apps.

Adam Zacks

-------------------------------------------

Be Nice, Or Leave

Post #604409

« Prev Topic | Next Topic »

Permissions