May 5, 2009 at 5:10 am
my d:\\ drive was full. i wnt to some space to D:\\ .
May 5, 2009 at 5:21 am
U mean the issue is due to SQL server?
Shrink the db having high log file size.
Check the temp DB, if its huge and ur server is not production then restart sql server.
May 5, 2009 at 5:26 am
eda pulikuttaaaaaaaaaaa.....................nee ivvidem vanno 😛
Hi,
Is the SQL server installed in D drive
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
May 5, 2009 at 6:23 am
Provide more info:
There are many options Like:
1. Shrink file
2. move .mdf or .ldf files
3. Purge data
4. delete unwanted files from the drive.
5. delete old back file if not required.
Might be one suites your requirement. 😛
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2009 at 6:55 am
goparaju.chandu (5/5/2009)
my d:\\ drive was full. i wnt to some space to D:\\ .
Mke sme space by delting some file you no lnger need.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
May 5, 2009 at 7:14 am
goparaju.chandu (5/5/2009)
my d:\\ drive was full. i wnt to some space to D:\\ .
What else resides on this drive? Can additional hard rives be added to the partition? Can you archive anything? What are the recovery modes of the databases? If full recovery, are you doing T-Log backups on a regular basis to keep the sizes manageable?
Ratheesh.K.Nair (5/5/2009)
U mean the issue is due to SQL server?Shrink the db having high log file size.
Check the temp DB, if its huge and ur server is not production then restart sql server.
While shrinking might be the first knee-jerk reaction, the underlying cause of the issue must be addressed as well. Also, if tempdb is large, there is an obvious reason for it, be it database maintenance or a large, potential runaway query???
Bottomline, analysis must be done to determine why the drive has filled up - unless it's simply the nature of the application being run and the OP not measuring growth metrics and being caught unprepared, IMO.
-- You can't be late until you show up.
May 5, 2009 at 7:39 am
goparaju.chandu (5/5/2009)
my d:\\ drive was full. i wnt to some space to D:\\ .
Buy a bigger drive. Or add more drives to the array.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 9:35 am
Ratheesh.K.Nair (5/5/2009)
U mean the issue is due to SQL server?Shrink the db having high log file size.
Check the temp DB, if its huge and ur server is not production then restart sql server.
Perhaps you can shrink tempdb instead of having to restart sql
May 5, 2009 at 9:52 am
homebrew01 (5/5/2009)
Ratheesh.K.Nair (5/5/2009)
U mean the issue is due to SQL server?Shrink the db having high log file size.
Check the temp DB, if its huge and ur server is not production then restart sql server.
Perhaps you can shrink tempdb instead of having to restart sql
Never a good idea. If an application is using tempdb and you're shrinking it, it can, and probably will, corrupt the database it's using.
-- You can't be late until you show up.
May 5, 2009 at 9:55 am
Well, without more info, my advice would be to delete some stuff you don't need.
May 5, 2009 at 12:34 pm
Shrink tempdb? Who said tempdb was on that drive?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 5, 2009 at 12:41 pm
I think someone assumed all data on the same drive, which is likely for many installations.
May 5, 2009 at 12:43 pm
Steve Jones - Editor (5/5/2009)
I think someone assumed all data on the same drive, which is likely for many installations.
I realize that, but you know what we say around the water fountain about assume ......
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 5, 2009 at 12:49 pm
Yep, it's usually me too!
😀
May 5, 2009 at 1:41 pm
Alvin Ramard (5/5/2009)
Shrink tempdb? Who said tempdb was on that drive?
Since the OP didn't give us much info, we're left to speculate wildly to cover all possible scenarios.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply