Posted by PFI on 08/22/06 08:25

I was not patient enough... Increasing the log file of msdb to 50Mb
took more than 10 minutes....

However, as you recommended, nstalling the SP1 solved the problem....

Thanks for your help
Patrick
Erland Sommarskog a écrit :

> PFI (patrick.fiche@aqsacom.com) writes:
> > I recently installed SQL Server 2005 Enterprise Edition (9.0.1399) and
>
> First of all, that's the RTM version. I recommend that you download
> and install SP1. http://www.microsoft.com/sql/sp1.mspx
>
> > I have problems on queries concerning system file manipulation...
> > For example, when I try to increase the Log File of MSDB database :
> > ALTER DATABASE msdb
> > MODIFY FILE
> > (NAME = 'MSDBLog',
> > SIZE = 50MB)
> >
> > This query never terminates...
> >
> > All SQL queries for database creation never terminate
>
> Compress drive? Network share? Have you tried to reboot the server?
> Have you checked in task manager if there is any CPU? Or any other tools
> to check for activity?
>
> Sorry, not much of answer, but it's difficult to diagnose a system without
> access to it.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]