September 8, 2009 at 2:56 pm
Hi friends
I'm running shareportal and the drive where db was located reached the size limit. The database becomes non-operational. File log is huge. the last backup of this clients is about 1 year old. I'm running Sql server 2008.
i think that server admins move db files to other disk drive.
my attemts to recover database leaves me with a db in emergency mode now.
I've tried attach mdf without ldf file unsuccessfuly
now, i took both mdf and ldf files and have them in my box with sql server 2008 installed.
I need to attach and recover data
Please help me!
(sorry my bad english)
September 8, 2009 at 3:31 pm
You're most likely in the FULL recovery model and you're not taking log backups - in which case it will grow forever. Either start taking log backups or switch to the SIMPLE recovery model (which will allow the log to clear but you lose the ability to do point-in-time restores).
Here are some links for you with more info:
Search Engine Q&A #1: Running out of transaction log space
Search Engine Q&A #23: My transaction log is full - now what?
TechNet Magazine: feature article on understanding logging and recovery
Importance of proper transaction log size management
Hope this helps.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 9, 2009 at 5:51 pm
Paul has right (as always ?:P)
Sharepoint's database have by default FULL recovery model turned on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply