Posted by PFI on 08/21/06 16:16

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

• Next in forum: Re: Recommendation for tools converting access databases to SQL
• Prev in forum: Re: sqlserver 2005: indexes on raid-0?
• Thread view: SQL Server 2005 - FILE manipulation hanging....

[Reply to this message]