SQL Server 2005 - FILE manipulation hanging....

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\DATA\Easyshare\EasyshareData.mdf',
SIZE = 200MB,
MAXSIZE = 1000MB,
FILEGROWTH = 100MB
)
LOG ON
(
NAME = EASYSHARELog,
FILENAME = 'E:\AQSALOG\Easyshare\EasyshareLog.ldf',
SIZE = 100MB,
MAXSIZE = 300MB,
FILEGROWTH = 50MB
)

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

Thanks
Patrick

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

PFI (patrick.fiche@aqsacom.com) writes:First of all, that's the RTM version. I recommend that you download
and install SP1. http://www.microsoft.com/sql/sp1.mspx
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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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 :