Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

general question about DB space Expand / Collapse
Author
Message
Posted Monday, November 17, 2008 3:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 9, 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
Posted Tuesday, November 18, 2008 7:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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
Posted Tuesday, November 18, 2008 7:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,096, Visits: 1,334
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 »

Add to briefcase

Permissions Expand / Collapse