SQL Server 2005 - FILE manipulation hanging....

Giganews Newsgroups
Subject: SQL Server 2005 - FILE manipulation hanging....
Posted by:  PFI (patrick.fic…@aqsacom.com)
Date: 21 Aug 2006

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

Replies