November 17, 2008 at 3:50 pm
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. 🙂
November 18, 2008 at 7:31 am
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.
November 18, 2008 at 7:56 am
A stupid question really. Especially given MS's liking for disk-hungry apps.
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply