148 reputation
6
bio website careers.stackoverflow.com/…
location Michigan
age
visits member for 3 years, 3 months
seen Nov 13 at 3:03

Jan
8
comment Log File over 400gigs…need to bring this database back to life
kevinsky - True, but some companies resort to stuff like this to save money. The better option would be to hire a dba or at least get short term help. I was able to fix this although it was rough. I had to actually restore the huge trans log file, then shrink it up. See the chat log for more details. Thanks Katherine, you get +1 :).
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Hi Katherine I am in the chat but do not see your responses?
Jan
8
comment Log File over 400gigs…need to bring this database back to life
I already tried that before after a google search CREATE DATABASE SharePoint_Config ON (FILENAME = N'S:\Databases\SP2010\SharePoint_Config.mdf') FOR ATTACH_REBUILD_LOG GO
Jan
8
comment Log File over 400gigs…need to bring this database back to life
And here is the error I get when doing that: File activation failure. The physical file name "L:\Logs\Databases\SP2010\SharePoint_Config_log.LDF" may be incorrect. The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure. Msg 1813, Level 16, State 2, Line 1 Could not open new database 'SharePoint_Config'. CREATE DATABASE is aborted.
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Right that is what I did...this is the command:EXEC sp_attach_single_file_db @dbname='SharePoint_Config', @physname=N'S:\Databases\SP2010\SharePoint_Config.mdf'
Jan
8
comment Log File over 400gigs…need to bring this database back to life
I got that error when executing your command. The thing is there is no log file in that path because as I mentioned I cannot restore it as it is over 400 gigs!
Jan
8
comment Log File over 400gigs…need to bring this database back to life
I am having no luck with this...File activation failure. The physical file name "L:\Logs\Databases\SP2010\SharePoint_Config_log.LDF" may be incorrect. The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure. Msg 1813, Level 16, State 2, Line 1 Could not open new database 'SharePoint_Config'. CREATE DATABASE is aborted.
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Hi Katherine, here is the image screen shot: imgur.com/xEIi3MT
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Hi Katherine, I guess management studio sees this database name already (SharePoint_Config). However, there is no log file associated with it because I never restored the log file. Because there is no log file I cannot expand the database. I can take a screen shot and post it to my question if you want?
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Hi Katherine, I will try this out in about 10 minutes, waiting for the completion of some other databases but I will report back. Thank you
Oct
3
comment SQL Server 2005 Memory Pressure
I was going to say I we had similiar issues but we found our issue due to multiple instances on one server. Memory was not allocated properly to each instance. But yours might be a different issue.
Oct
3
comment SQL Server 2005 Memory Pressure
do you have one instance of sql server, or do you have multiple instances on one box?