You are here: SQL Server 2005 - FILE manipulation hanging.... « MsSQL Server « IT news, forums, messages
SQL Server 2005 - FILE manipulation hanging....

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация