August 6, 2012 at 4:35 pm
MyDoggieJessie (8/6/2012)
i check in that table, that table is basically contains records for all log entries for the database, right now it contains 25 million records. so i need to talk to my manager and need to delete some of record so we have some space to do re-index
what your recommendation for this?
How much free space do you have available?
I have around 11GB available for that drive.
August 6, 2012 at 5:52 pm
Please describe in detail your server, storage, data files, log files, tempdb location, etc...
Do you have space on other drives? Are you data files and log files all on the same drive?
Do you have to keep all this data? Can you back it up to an external storage?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 5:56 pm
You may be able to get away with just increasing your data file a few GB...try that first...then we can look at other options. So if you data files is maxed out at 95GB, make it 100GB - I forgot to ask earlier...is this a production server? If so, is it under a heavy load?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 6:41 pm
Do you have space on other drives? Are you data files and log files all on the same drive?
No i Dont have sufficeint space on other drive.
Yes, i have all system database and other database's data and log files on same Drive.
Can you back it up to an external storage?
I place backup on other server
..is this a production server?
Yes, this is a production server.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply