SQL Server 2005 - FILE manipulation hanging....
- From: "PFI" <patrick.fiche@xxxxxxxxxxx>
- Date: 21 Aug 2006 09:16:14 -0700
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
.
- Follow-Ups:
- Re: SQL Server 2005 - FILE manipulation hanging....
- From: Erland Sommarskog
- Re: SQL Server 2005 - FILE manipulation hanging....
- Prev by Date: Re: sqlserver 2005: indexes on raid-0?
- Next by Date: Re: Recommendation for tools converting access databases to SQL
- Previous by thread: Difference between 2 tables
- Next by thread: Re: SQL Server 2005 - FILE manipulation hanging....
- Index(es):
Relevant Pages
|