SQL Server 2005 - FILE manipulation hanging....

[PFI]

Hi,

I recently installed SQL Server 2005 Enterprise Edition (9.0.1399) and
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
CREATE DATABASE EASYSHARE
ON PRIMARY
(
NAME = EASYSHAREData,
FILENAME = 'D:\AQSACOM\DAT A\Easyshare\Eas yshareData.mdf' ,
SIZE = 200MB,
MAXSIZE = 1000MB,
FILEGROWTH = 100MB
)
LOG ON
(
NAME = EASYSHARELog,
FILENAME = 'E:\AQSALOG\Eas yshare\Easyshar eLog.ldf',
SIZE = 100MB,
MAXSIZE = 300MB,
FILEGROWTH = 50MB
)

Would someone have an idea of what happens...
I'm running on Windows 2000 Server...

Thanks
Patrick

[Erland Sommarskog]

Re: SQL Server 2005 - FILE manipulation hanging....

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@sommarsk og.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

[PFI]

Re: SQL Server 2005 - FILE manipulation hanging....

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@sommarsk og.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/prodinf...ons/books.mspx