September 17, 2004 at 3:52 pm
Hi guys's
Can someone please tell me how I can increase my database space..right now it's showing zero..the database size is 419MB
When I right click on the database and select the property tab. it's showing me space available is 0 and I'm also having problems in backing up and restoring the same database on my logshipping machine.
thanks, I appreciate you help.
Mn
September 17, 2004 at 4:49 pm
In the database properties tab you can allocate additional space for your database. You can also ensure that your datafiles grow by either a megabyte amount or percentage when you reach a certain size threshold. If you have no problem allowing your database to grow then allocate more space and set it to grow by 10%. You should do the same with the transaction log file as long as the database is not in simple recovery mode.
Jason
September 17, 2004 at 5:48 pm
Thanks Jason for the reply.
My database is in Full Recovery mode and the spaces allocated to both the database file and the transaction log file is set to 406 and 15 MB respectively and both the databases are growing by 10% but the available size is showing 0MB on the General tab. Would there be any effects on the backups and restore when the available size is showing 0MB? Also, I have a job agent which is running every 10 mins to backup the transaction log which I'm restoring on my log shipping server. Whenever I'm trying to restore the logs on the log shipping server I'm getting error that, logs cannot be restore due to a problem contact the technical person. I wasn't getting this error until the available size went to 0MB. Can you please figure out what is the cause of the problem and how can I fix it.
Thanks for the help
Mn
September 22, 2004 at 1:47 pm
Try going into the data files section and manually allocating more space for your data file. As long as you have the space, type 1000 (1gig) or more into the allocated space field and SQL server will manually allocate the space for the data file. Your free space will then increase and your problem should dissapear (if it is related to free space). About your logs failing, this may or may not be the reason. If you can give an exact copy of the error message I can give my input but the error message is so general its tough to tell whats going on.
Jason
September 23, 2004 at 6:48 am
Also look out to your Hard Drive and make sure you haven't filled the drive up with something else. If there is no available space on the hard drvie your file cannot grow.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply