If those inserts are incapsulated into one transaction, it's possible it will grow to 95GB.  If this is only a one time process, you can backup the transaction log and...

thank you so much for your quick response!  I have tested this one out but just want to make sure I'm 100% sure.

Well i'm just planning to move the log files to a different drive for performance on an active/passive sql cluster.  do i still need to synchronize users and passwords?

Thanks!

I fixed the problem.  After digging into the problem, i found out that SQL Server agent is having problem connecting to the DB and there's alot of error regarding SQL...

Thanks for your response!  We actually fixed the problem.  Somehow my colleague tried restoring the db(140GB) but it failed because of low disk space on the drive that stores the...

Guys....i really need some help here...any possible directions will do.

thanks,

Thanks Steve!  Yes we tried testing it on our test server and it didn't corrupt the DB so you're right on that.

Thanks again...

The used space on the log file do shrink but the file doesn't.  Log file doesn't shrink once it's been increase. any more thoughts?

cool!  glad it worked out for you...

it's 30GB.

who's the owner of the msdb database?  It's a tale-tale sign that it's owned by the domain user account you're using for the mssql service.  If it is then change...

Follow the procedures from this link: http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Make sure you login as SA.  The ramnifications of leaving it like this is you'll still be able to execute jobs but new...

Gurus,

Thank you for all your advise!  We're currently using SQL Server with our hr/payroll program(Kronos).  I'll be doing a presentation next week on this issue and I'll be putting your...

ok our SAN engineer looked at all the hypers and yes there were a couple of them that have a lot of hotspots around that time of performance degradation.  I...

Sure do Jeff...I think we're using DMX 800 SAN Storage System.  For the H drive, it's in a raid 5 configuration and the log files(G) is raid 1.  I agree...